Coal miners' health big data platform system based on mining smart positioning bracelet

Abstract

The present invention provides a coal miner health big data platform system based on a mine-used smart positioning bracelet, which belongs to the field of mine positioning and health management technology, including a mine-used smart positioning bracelet, ground communication equipment and underground communication equipment; the ground communication equipment includes a general dispatching station and several ground wireless base stations; the underground communication equipment includes several underground precise positioning base stations and several underground wireless base stations; the mine-used smart positioning bracelet collects the coal miner's physical health data and motion information data both on the ground and underground; the mine-used smart positioning bracelet locates the personnel position on the ground by satellite, and locates the personnel position underground by UWB positioning. The present invention collects the coal miner's physical health data and personnel position positioning information through the mine-used smart positioning bracelet and provides them to the general dispatching station, and statistically analyzes the coal miner's physical health data, and promptly issues an alarm for abnormal physical health data.

Description

Technical Field

[0001] The present invention belongs to the technical field of mine positioning and health management, and in particular relates to a coal miner health big data platform system based on a mine smart positioning bracelet. Background Art

[0002] Coal mine safety has always been an issue that needs to be focused on. The health of coal miners is an important part of coal mine safety. When coal miners are working underground, supervisors cannot know the physical condition of coal miners at any time. Coal miners cannot grasp the surrounding environment and their own physical condition in time when working underground. The physical condition of coal miners directly affects the progress of mining. They cannot escape in time when encountering dangerous situations. In addition, coal miners have to carry multiple smart cards, which is very inconvenient.

[0003] Existing smart bracelets can partially monitor the human body's physical condition and locate personnel, but the personnel positioning method underground in coal mines is one-dimensional or two-dimensional positioning, which is different from the positioning method of existing smart bracelets. Moreover, existing smart bracelets are mainly used on the ground, and the communication methods between the ground and underground in coal mines are different. Therefore, existing smart bracelets cannot be used directly in coal mines, and cannot monitor the health status of coal miners or locate personnel underground.

[0004] This is the deficiency of the prior art. Therefore, in view of the above-mentioned defects in the prior art, it is very necessary to provide a coal miner health big data platform system based on a mining smart positioning bracelet. Summary of the invention

[0005] In view of the defects of the prior art that the above-mentioned existing smart bracelets cannot be used directly underground in coal mines, cannot monitor the health status of coal miners, and cannot locate personnel underground, the present invention provides a coal miner health big data platform system based on a mining smart positioning bracelet to solve the above technical problems.

[0006] The present invention provides a coal miner health big data platform system based on a mine-based smart positioning wristband, including a mine-based smart positioning wristband, ground communication equipment and underground communication equipment;

[0007] Ground communication equipment includes a general dispatching console and several ground wireless base stations;

[0008] The underground communication equipment includes several underground precise positioning base stations and several underground wireless base stations;

[0009] The mining smart positioning bracelet collects the health data and exercise information of coal miners both on the ground and underground;

[0010] The mining smart positioning bracelet locates personnel on the ground through positioning satellites, and locates personnel underground through UWB positioning.

[0011] The intelligent positioning bracelet for mining uploads the health data and location information of coal miners to the general dispatching platform through the ground wireless base station on the ground, and uploads it to the general dispatching platform through the underground wireless base station underground;

[0012] The general dispatching platform conducts statistical analysis on the physical health data of coal miners and issues alarms when the physical health data of coal miners are abnormal.

[0013] Furthermore, the ground communication equipment also includes a core switch, a wellhead switch, and several ground switches;

[0014] The downhole communication equipment also includes downhole switches;

[0015] The core switch is connected to the general dispatching platform, and the ground switch is connected to each ground wireless base station;

[0016] The underground switch is connected to each underground precise positioning base station and each underground wireless base station;

[0017] The core switch, wellhead switch, ground switches and underground switches form a 10G ring network;

[0018] The ground wireless base station and the underground wireless base station package the coal miners' health data and personnel location information collected by the mine smart positioning bracelet according to the set data format, and then encrypt the packaged data and send it to the general dispatching platform. The ground wireless base station and the underground wireless base station package the miners' health data and personnel location information into json format, and send the key data in the json format data, such as the password corresponding to the user account, to the general dispatching platform using salted double MD5 encryption to ensure data security.

[0019] Furthermore, the mining smart positioning bracelet includes a health data collection unit, a sports data collection unit, a smart positioning identification card, a communication unit and a display unit;

[0020] The health data collection unit includes a heart rate detection chip and a human body temperature recognition chip;

[0021] Heart rate detection chip, used to collect heart rate data of coal miners wearing mining smart positioning bracelets;

[0022] Human body temperature recognition chip, used to collect body temperature data of coal miners wearing mining smart positioning bracelets;

[0023] The motion state data acquisition unit includes a gyroscope and a vibration switch;

[0024] When the vibration switch is triggered, the gyroscope is used to identify the coal miner's steps and collect the number of steps;

[0025] The smart positioning identification card locates personnel on the ground through satellites, connects to the precise positioning base station underground, and locates personnel through UWB positioning;

[0026] The communication unit includes a surface communication interface and a downhole communication interface;

[0027] A communication unit is used to connect to a ground wireless base station on the ground and to connect to an underground wireless base station underground to achieve communication with the general dispatching platform;

[0028] The display unit includes a display screen;

[0029] The display unit is used to display the collected health data of coal miners, personnel location information, and information pushed by the general dispatching platform. The gyroscope is combined with the vibration switch to realize the collection of step counts.

[0030] Furthermore, the overall dispatching platform includes a data storage module, a data statistical analysis module, a data display module, a database module, a data query module, a positioning information push module, and a broadcast information generation module;

[0031] The data storage module is used to receive the coal miners' health data, coal miners' movement information data and personnel location information collected by the mining smart positioning bracelet, and encrypt and store the data in the database module;

[0032] The data statistical analysis module is used to classify and statistically analyze the data in the database module to generate a health status analysis table, and to issue an alarm when the health data of coal miners is abnormal;

[0033] The data display module is used to display body temperature data, heart rate data, exercise data and location data in the form of a line chart;

[0034] The database module is used to store user tables, temperature data tables, heart rate data tables, exercise data tables, location data tables, and health status analysis tables according to data classification;

[0035] The data query module is used to set the query interface and query the required body temperature data, heart rate data, exercise data and location data in each table of the database module according to the query conditions;

[0036] The positioning information push module is used to generate a safe escape route for each coal miner based on the location information of each coal miner and the underground mine map when an emergency occurs in the coal mine, and push it to the corresponding coal miner through the mine smart positioning bracelet;

[0037] The broadcast information generation module is used to search for coal miners in the same area within the range set by the coal miner according to the location information of the coal miner when a coal miner is in distress, and push the location information of the coal miner in distress to the mining smart bracelets of all coal miners in the same area to start emergency rescue. The general dispatching platform is built on a cloud server, with an operating system of Ubuntu 17.04 and a backend of Django 2.0 or above, which is convenient for connecting to the database on MySQL 5.7; the general dispatching platform implements storage, statistical analysis, display and query functions through modules. Each coal miner can learn about the status of other coal miners around him and perform dispatching tasks through the broadcast information pushed by the dispatching platform, so that once someone is in distress, the surrounding people can carry out rescue nearby.

[0038] Furthermore, the data statistical analysis module includes a data classification unit, a data analysis unit and a health warning unit;

[0039] A data classification unit, used for classifying according to body temperature data, heart rate data, motion data and location data;

[0040] The data analysis unit is used to comprehensively analyze the body temperature data, heart rate data and exercise data of the coal miners, generate a health analysis table, and obtain the original health big data of the mining smart positioning bracelet from the database module, and compare the health big data with the data in the health analysis table to determine whether the health status of the coal miners is abnormal;

[0041] The health warning unit is used to conduct health risk assessments when coal miners are in abnormal health conditions, determine the health risk level, and generate guidance plans of corresponding levels to push to coal miners;

[0042] When the health status exceeds the threshold, the location data of the coal miners is obtained, and an emergency call message is generated and pushed to the monitoring personnel. Through data analysis, the health status of the coal miners is evaluated, and the corresponding level of guidance is pushed to the coal miners for low health risk situations. For high-risk or even dangerous situations, it needs to be pushed to the monitoring personnel, and the coal miners need to be searched and rescued based on the location data.

[0043] Furthermore, the data display module includes:

[0044] The temperature data display unit is used to display the daily temperature data in the form of a line chart, where the horizontal axis is time and the vertical axis is temperature, with hours as the horizontal axis unit and the highest temperature in the unit time as the vertical axis corresponding temperature value;

[0045] The heart rate data display unit is used to display the daily heart rate data in the form of a line chart, where the horizontal axis is time and the vertical axis is heart rate, with hours as the horizontal axis unit and the average heart rate per unit time as the vertical axis corresponding heart rate value;

[0046] The exercise data display unit is used to display the weekly exercise data in the form of a line chart, where the horizontal axis is time and the vertical axis is the number of steps, with days as the horizontal axis unit and the cumulative number of steps per unit time as the corresponding step value on the vertical axis;

[0047] The location data display unit is used to display the location data of the current time point and the set time period in the form of a line chart, and form a historical trajectory within the set time period and a personnel heat distribution map; the location data is the horizontal and vertical coordinate points of the coal miner's location. The body temperature data display unit uses the daily body temperature data of each coal miner as a graph, and the database module retains the body temperature conditions of the last 15 days; the heart rate data display unit uses the daily heart rate data of each coal miner as a graph, and the database module retains the heart rate conditions of the last 7 days; the exercise data display unit uses the weekly exercise conditions of each coal miner as a graph, and the database module retains the exercise conditions of the last month; the location data display unit can display the location data of coal miners in real time and can play back historical trajectories.

[0048] Furthermore, the database module uses a connection pool of MySQL version 5.7 or higher, including 10 sub-databases;

[0049] The database module establishes associations between various tables according to user accounts. The user table stores passwords and user account fields, the temperature data table stores user accounts, time and temperature fields, the heart rate data table stores user accounts, time and heart rate fields, the exercise data table stores user accounts, time and step fields, the location data table stores user accounts, time and location data fields, and the health status analysis table stores user accounts, time and physiological index fields, and the physiological index is the comprehensive data of body temperature, heart rate and step number. The connection of 10 sub-databases reduces the pressure on the database module.

[0050] Furthermore, the data query module uses the Django 2.0 or higher version of the Web framework to connect to the connection pool of the database module;

[0051] The data query module includes a user login unit, a body temperature data query unit, a heart rate data query unit, a motion data query unit, and a location data query unit;

[0052] The user login unit is used to obtain the user login account and password, query the corresponding password from the user table with the user login account as the primary key, and allow the user to log in if the two passwords are consistent;

[0053] The temperature data query unit is used to query the corresponding temperature data from the temperature data table based on the user's temperature query request after the user logs in, using the user account and time as the primary key;

[0054] A heart rate data query unit is used to query the corresponding heart rate data from the heart rate data according to the user's heart rate query request after the user logs in, using the user account and time as the main key;

[0055] A sports data query unit, which is used to query sports data from a sports data table based on a user's sports data query request after the user logs in, using the user account and time as primary keys;

[0056] The location data query unit is used to query the location data from the location data table based on the user's location data query request after the user logs in, using the user account and time as the primary key. The units in the database query module are associated with each other based on the user account. The temperature data query unit, heart rate data query unit, exercise data query unit, and location data query unit use a composite primary key to improve the query speed.

[0057] Further, the ground communication equipment also includes an uninterruptible power supply;

[0058] The uninterruptible power supply is connected to the core switch, wellhead switch, various ground switches and various ground wireless base stations;

[0059] Underground communication equipment includes mine-use flameproof and intrinsically safe uninterruptible power supply;

[0060] The mine flameproof and intrinsically safe uninterruptible power supply is connected to both the underground precise positioning base station and the underground wireless base station. The uninterruptible power supply supplies power to the ground communication equipment, while the mine flameproof and intrinsically safe uninterruptible power supply supplies power to the underground communication equipment.

[0061] Furthermore, the smart positioning identification card locates the personnel on the ground through GPS or Beidou satellite;

[0062] The smart positioning identification card sends data signals to each underground precise positioning base station. The adjacent underground precise positioning base stations use the TOF algorithm or TODA algorithm to calculate the distance between the smart positioning identification card and the underground precise positioning base station based on the data signal sent by the same smart positioning identification card, and then obtain the location data of the coal miner in the mine.

[0063] The smart positioning identification card periodically detects the strength of the ground satellite signal and the underground precise positioning base station signal. When it is detected that the ground satellite signal strength is lower than the first threshold, and the underground precise positioning base station signal is higher than the second threshold, it is determined that the coal miner has entered the underground from the ground, and the communication between the smart positioning identification card and the underground precise positioning base station is first started, and then the communication between the smart positioning identification card and the satellite is disconnected;

[0064] When it is detected that the signal of the underground precise positioning base station is lower than the third threshold, and the ground satellite signal strength is higher than the fourth threshold, it is determined that the coal miner has come to the ground from the underground. The communication between the smart positioning identification card and the satellite is first started, and then the communication between the smart positioning identification card and the underground precise positioning base station is disconnected. When the smart positioning identification card switches between the ground and the underground, it is positioned by connecting first and then disconnecting to prevent entering the positioning blind area and losing the location data, thereby ensuring the accuracy of positioning. The smart positioning identification card connects to the underground precise positioning base station underground using the UWB positioning method, and calculates the position of the coal miner through three-dimensional positioning.

[0065] The beneficial effects of the present invention are:

[0066] The coal miner health big data platform system based on the mining smart positioning bracelet provided by the present invention collects the physical health data and personnel location information of the coal miners through the mining smart positioning bracelet and provides them to the general dispatching station, and performs statistical analysis on the physical health data of the coal miners, and promptly issues alarms for abnormal physical health data.

[0067] In addition, the invention has a reliable design principle, a simple structure and a very broad application prospect.

[0068] It can be seen that compared with the prior art, the present invention has outstanding substantive features and significant progress, and the beneficial effects of its implementation are also obvious. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0070] Figure 1 It is a schematic diagram of the coal miner health big data platform system based on the mining smart positioning bracelet of the present invention.

[0071] Figure 2 It is a structural schematic diagram of the mining intelligent positioning bracelet of the present invention.

[0072] Figure 3 It is a schematic diagram of the general dispatching console of the coal miner health big data platform system based on the mining intelligent positioning bracelet of the present invention.

[0073] In the figure, 1- intelligent positioning bracelet for mining; 1.1- heart rate detection chip; 1.2- human body temperature recognition chip; 1.3- gyroscope; 1.4- vibration switch; 1.5- intelligent positioning identification card; 1.6- ground communication interface; 1.7- underground communication interface; 1.8- display screen; 2- general dispatching platform; 3- ground wireless base station; 4- underground precise positioning base station; 5- underground wireless base station; 6- positioning satellite; 7- core switch; 8- wellhead switch; 9- ground switch; 10- underground switch; 11- data storage module; 12- data statistics analysis module; 12.1- data analysis module Class unit; 12.2-data analysis unit; 12.3-health warning unit; 13-data display module; 13.1-body temperature data display unit; 13.2-heart rate data display unit; 13.3-exercise data display unit; 13.4-position data display unit; 14-database module; 15-data query module; 15.1-user login unit; 15.2-body temperature data query unit; 15.3-heart rate data query unit; 15.4-exercise data query unit; 15.5-position data query unit; 16-positioning information push module; 17-broadcast information generation module. DETAILED DESCRIPTION

[0074] In order to enable those skilled in the art to better understand the technical solutions in the present invention, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0075] The key terms appearing in the present invention are explained below.

[0076] UWB is the abbreviation of Ultra Wide Band. Ultra-wideband technology is a wireless carrier communication technology. It does not use a sinusoidal carrier, but uses nanosecond non-sinusoidal narrow pulses to transmit data. UWB technology has the advantages of low system complexity, low power spectrum density of transmitted signals, insensitivity to channel fading, low interception capability, and high positioning accuracy. It is especially suitable for high-speed wireless access in dense multipath places such as indoors.

[0077] TOF is the abbreviation of Time of flight, which is the time difference method. The time-of-flight ranging method belongs to the two-way ranging method, which mainly uses the flight time of the signal between two transceivers to measure the distance between nodes.

[0078] TODA, short for Time Difference Of Arrival, is the time difference of arrival method, which mainly locates the target by comparing the different arrival times of the same target signal collected by multiple sensors.

[0079] Embodiment 1:

[0080] like Figure 1 As shown, the present invention provides a coal miner health big data platform system based on a mining smart positioning bracelet, including a mining smart positioning bracelet 1, ground communication equipment and underground communication equipment;

[0081] The ground communication equipment includes a general dispatching station 2 and several ground wireless base stations 3;

[0082] The underground communication equipment includes a number of underground precise positioning base stations 4 and a number of underground wireless base stations 5;

[0083] The mining smart positioning bracelet 1 collects the health data and sports information data of coal miners both on the ground and underground;

[0084] The mining smart positioning bracelet 1 locates the personnel position on the ground through the positioning satellite 6, and locates the personnel position underground through the UWB positioning method;

[0085] The mining smart positioning bracelet 1 uploads the coal miner's health data and personnel location information to the general dispatching platform 2 through the ground wireless base station 3 on the ground, and uploads it to the general dispatching platform 2 through the underground wireless base station 5 underground;

[0086] The general dispatching platform 2 performs statistical analysis on the health data of coal miners and issues an alarm when the health data of coal miners is abnormal;

[0087] The ground communication equipment also includes a core switch 7, a wellhead switch 8 and several ground switches 9;

[0088] The downhole communication equipment also includes a downhole switch 10;

[0089] The core switch 7 is connected to the general dispatching platform 2, and the ground switch 9 is connected to each ground wireless base station 3;

[0090] The underground switch 10 is connected to each underground precise positioning base station 4 and each underground wireless base station 5;

[0091] The core switch 7, the wellhead switch 8, each surface switch 9 and each underground switch 10 form a 10G ring network;

[0092] The ground wireless base station 3 and the underground wireless base station 5 package the coal miner's health data and personnel location information collected by the mine smart positioning bracelet 1 according to the set data format, and then encrypt the packaged data and send it to the general dispatching platform 2;

[0093] Ground communications equipment also includes uninterruptible power supplies;

[0094] The uninterruptible power supply is connected to the core switch 7, the wellhead switch 8, each ground switch 9 and each ground wireless base station 3;

[0095] Underground communication equipment includes mine-use flameproof and intrinsically safe uninterruptible power supply;

[0096] The mine flameproof and intrinsically safe uninterruptible power supply is connected to the underground precise positioning base station 4 and the underground wireless base station 5;

[0097] like Figure 2 As shown, the mining smart positioning bracelet 1 includes a health data collection unit, a sports data collection unit, a smart positioning identification card 1.5, a communication unit and a display unit;

[0098] The health data collection unit 1 includes a heart rate detection chip 1.1 and a human body temperature recognition chip 1.2;

[0099] Heart rate detection chip 1.1, used to collect heart rate data of coal miners wearing mining smart positioning bracelets;

[0100] Human body temperature recognition chip 1.2, used to collect body temperature data of coal miners wearing mining smart positioning bracelets;

[0101] The motion state data acquisition unit includes a gyroscope 1.3 and a vibration switch 1.4;

[0102] When the vibration switch 1.4 is triggered to start, the gyroscope 1.3 identifies the steps of the coal miner and collects the number of steps;

[0103] The intelligent positioning identification card 1.5 locates the personnel position on the ground through satellite, connects to the underground precise positioning base station 4 underground, and locates the personnel position through UWB positioning;

[0104] The communication unit includes a surface communication interface 1.6 and a downhole communication interface 1.7;

[0105] A communication unit, used to connect to the ground wireless base station 3 on the ground and to connect to the underground wireless base station 5 underground to achieve communication with the general dispatching platform 1;

[0106] The display unit includes a display screen 1.8;

[0107] The display unit is used to display the collected health data of coal miners and personnel location information and the information pushed by the general dispatching platform 2.

[0108] In the above-mentioned embodiment 1, the smart positioning identification card 1.5 locates the position of the person on the ground through GPS or Beidou satellite;

[0109] The smart positioning identification card 1.5 sends data signals to each underground precise positioning base station 4. The adjacent underground precise positioning base stations 4 use the TOF algorithm or TODA algorithm to calculate the distance between the smart positioning identification card 1.5 and the underground precise positioning base station, and then obtain the position data of the coal miner in the underground.

[0110] The smart positioning identification card 1.5 periodically detects the strength of the ground satellite signal and the underground precise positioning base station signal. When it is detected that the ground satellite signal strength is lower than the first threshold, and the underground precise positioning base station signal is higher than the second threshold, it is determined that the coal miner has entered the underground from the ground, and the communication between the smart positioning identification card 1 and the underground precise positioning base station 4 is first started, and then the communication between the smart positioning identification card 1 and the satellite 6 is disconnected;

[0111] When it is detected that the signal of the underground precise positioning base station is lower than the third threshold, and the ground satellite signal strength is higher than the fourth threshold, it is determined that the coal miner has come to the ground from the mine, and the communication between the smart positioning identification card 1 and the satellite 6 is first started, and then the communication between the smart positioning identification card 1 and the underground precise positioning base station 4 is disconnected.

[0112] Embodiment 2:

[0113] like Figure 3 As shown, different from the above-mentioned embodiment 1, the general dispatching platform 2 includes a data storage module 11, a data statistical analysis module 12, a data display module 13, a database module 14, a data query module 15, a positioning information push module 16 and a broadcast information generation module 17;

[0114] The data storage module 11 is used to receive the coal miner's health data, coal miner's movement information data and personnel location information collected by the mining smart positioning bracelet 1, and encrypt and store each data in the database module 14;

[0115] The data statistical analysis module 12 is used to classify and statistically analyze the data of the database module 14 to generate a health status analysis table, and to issue an alarm when the health data of the coal miners is abnormal;

[0116] The data display module 13 is used to display the body temperature data, heart rate data, exercise data and location data in the form of a line chart;

[0117] The database module 14 is used to store the user table, the temperature data table, the heart rate data table, the exercise data table, the location data table and the health condition analysis table according to the data classification;

[0118] The data query module 15 is used to set a query interface and query the required body temperature data, heart rate data, motion data and location data in each table of the database module according to the query conditions;

[0119] The positioning information push module 16 is used to generate a safe escape route for each coal miner according to the personnel location information of each coal miner and the underground mine map when an emergency occurs in the coal mine, and push it to the corresponding coal miner through the mine smart positioning bracelet;

[0120] The broadcast information generating module 17 is used to search for coal miners in the same area within the set area of ​​the coal miner according to the personnel location information of the coal miner when a coal miner is in distress, and push the personnel location information of the coal miner in distress to the mining smart bracelets of all coal miners in the same area to start emergency rescue;

[0121] The data statistical analysis module 12 includes a data classification unit 12.1, a data analysis unit 12.2 and a health warning unit 12.3;

[0122] A data classification unit 12.1, for classifying according to body temperature data, heart rate data, motion data and position data;

[0123] The data analysis unit 12.2 is used to comprehensively analyze the body temperature data, heart rate data and movement data of the coal miners, generate a health status analysis table, and obtain the original health big data of the mining smart positioning bracelet from the database module, and compare the health big data with the data in the health status analysis table to determine whether the health status of the coal miners is abnormal;

[0124] The health warning unit 12.3 is used to conduct health risk assessment when the health status of coal miners is abnormal, determine the health status risk level, and generate a corresponding guidance plan to push to the coal miners;

[0125] When the health status level exceeds the threshold, the location data of the coal miner is obtained, and an emergency call message is generated and pushed to the monitoring personnel;

[0126] The data display module 13 includes:

[0127] The temperature data display unit 13.1 is used to display the daily temperature data in the form of a line chart, wherein the horizontal axis is time and the vertical axis is temperature, and the horizontal axis unit is hour, and the highest temperature in the unit time is the corresponding temperature value of the vertical axis;

[0128] The heart rate data display unit 13.2 is used to display the heart rate data of each day in the form of a line chart, wherein the horizontal axis is time and the vertical axis is heart rate, and the horizontal axis unit is hour, and the vertical axis corresponds to the heart rate value with the average heart rate per unit time;

[0129] The exercise data display unit 13.3 is used to display the weekly exercise data in the form of a line chart, wherein the horizontal axis is time and the vertical axis is the number of steps, and the horizontal axis unit is day, and the vertical axis corresponds to the number of steps accumulated in the unit time;

[0130] The location data display unit 13.4 is used to display the location data of the current time point and the set time period in the form of a line chart, and form a historical trajectory and a personnel heat distribution map within the set time period; the location data is the horizontal and vertical coordinate points of the coal miner's location;

[0131] The database module 14 uses a connection pool of MySQL version 5.7 or above, including 10 sub-databases;

[0132] The database module 14 establishes associations between various tables according to the user account, wherein the user table stores password and user account fields, the temperature data table stores user account, time and temperature fields, the heart rate data table stores user account, time and heart rate fields, the exercise data table stores user account, time and step number fields, the location data table stores user account, time and location data fields, and the health status analysis table stores user account, time and physiological index fields, wherein the physiological index is comprehensive data of body temperature, heart rate and step number;

[0133] The data query module 15 uses the Web framework of Django 2.0 or above to connect to the connection pool of the database module;

[0134] The data query module 15 includes a user login unit 15.1, a body temperature data query unit 15.2, a heart rate data query unit 15.3, a motion data query unit 15.4 and a position data query unit 15.5;

[0135] User login unit 15.1, used to obtain the user login account and password, query the corresponding password from the user table with the user login account as the primary key, and allow the user to log in if the two passwords are consistent;

[0136] The temperature data query unit 15.2 is used to query the corresponding temperature data from the temperature data table based on the user's temperature query request after the user logs in, using the user account and time as the primary key;

[0137] The heart rate data query unit 15.3 is used to query the corresponding heart rate data from the heart rate data according to the user's heart rate query request after the user logs in, using the user account and time as the main key;

[0138] The sports data query unit 15.4 is used to query sports data from the sports data table based on the user's sports data query request after the user logs in, using the user account and time as primary keys;

[0139] The location data query unit 15.5 is used to query the location data from the location data table based on the user's location data query request after the user logs in, using the user account and time as primary keys.

[0140] Although the present invention has been described in detail by referring to the accompanying drawings and in combination with the preferred embodiments, the present invention is not limited thereto. Without departing from the spirit and essence of the present invention, a person of ordinary skill in the art may make various equivalent modifications or substitutions to the embodiments of the present invention, and these modifications or substitutions shall be within the scope of the present invention. Any person of ordinary skill in the art may easily think of changes or substitutions within the technical scope disclosed by the present invention, and these shall be within the scope of protection of the present invention. Therefore, the scope of protection of the present invention shall be subject to the scope of protection of the claims.

Claims

1. A coal miner health big data platform system based on a mining smart positioning bracelet, characterized in that: Including mining smart positioning bracelets, ground communication equipment and underground communication equipment; Ground communication equipment includes a general dispatching console and several ground wireless base stations; The underground communication equipment includes several underground precise positioning base stations and several underground wireless base stations; The mining smart positioning bracelet collects the health data and exercise information of coal miners both on the ground and underground; The mining smart positioning bracelet locates personnel on the ground through positioning satellites, and locates personnel underground through UWB positioning. The intelligent positioning bracelet for mining uploads the health data and location information of coal miners to the general dispatching platform through the ground wireless base station on the ground, and uploads it to the general dispatching platform through the underground wireless base station underground; The general dispatching platform conducts statistical analysis on the health data of coal miners and issues an alarm when the health data of coal miners is abnormal; The ground communication equipment also includes core switches, wellhead switches and several ground switches; The downhole communication equipment also includes downhole switches; The core switch is connected to the general dispatching platform, and the ground switch is connected to each ground wireless base station; The underground switch is connected to each underground precise positioning base station and each underground wireless base station; The core switch, wellhead switch, ground switches and underground switches form a 10G ring network; The ground wireless base station and the underground wireless base station package the coal miners' health data and personnel location information collected by the mine smart positioning bracelet according to the set data format, and then encrypt the packaged data and send it to the general dispatching platform; The mining smart positioning bracelet includes a health data collection unit, a sports data collection unit, a smart positioning identification card, a communication unit and a display unit; The health data collection unit includes a heart rate detection chip and a human body temperature recognition chip; Heart rate detection chip, used to collect heart rate data of coal miners wearing mining smart positioning bracelets; Human body temperature recognition chip, used to collect body temperature data of coal miners wearing mining smart positioning bracelets; The motion state data acquisition unit includes a gyroscope and a vibration switch; When the vibration switch is triggered, the gyroscope is used to identify the coal miner's steps and collect the number of steps; The smart positioning identification card locates personnel on the ground through satellites, connects to the underground precise positioning base station, and locates personnel through UWB positioning; The communication unit includes a surface communication interface and a downhole communication interface; A communication unit is used to connect to a ground wireless base station on the ground and to connect to an underground wireless base station underground to achieve communication with the general dispatching platform; The display unit includes a display screen; A display unit is used to display the collected health data of coal miners and personnel location information and information pushed by the general dispatching platform; The general dispatching platform includes a data storage module, a data statistics analysis module, a data display module, a database module, a data query module, a positioning information push module, and a broadcast information generation module; The data storage module is used to receive the coal miners' health data, coal miners' movement information data and personnel location information collected by the mining smart positioning bracelet, and encrypt and store the data in the database module; The data statistical analysis module is used to classify and statistically analyze the data in the database module to generate a health status analysis table, and to issue an alarm when the health data of coal miners is abnormal; The data display module is used to display body temperature data, heart rate data, exercise data and location data in the form of a line chart; The database module is used to store user tables, temperature data tables, heart rate data tables, exercise data tables, location data tables, and health status analysis tables according to data classification; The data query module is used to set the query interface and query the required body temperature data, heart rate data, exercise data and location data in each table of the database module according to the query conditions; The positioning information push module is used to generate a safe escape route for each coal miner based on the location information of each coal miner and the underground mine map when an emergency occurs in the coal mine, and push it to the corresponding coal miner through the mine smart positioning bracelet; The broadcast information generation module is used to search for coal miners in the same area within the set area of ​​the coal miner according to the personnel location information of the coal miner when a coal miner is in distress, and push the personnel location information of the coal miner in distress to the mining smart bracelets of all coal miners in the same area to start emergency rescue; The smart positioning identification card locates the personnel on the ground through GPS or Beidou satellite; The smart positioning identification card sends data signals to each underground precise positioning base station. The adjacent underground precise positioning base stations use the TOF algorithm or TODA algorithm to calculate the distance between the smart positioning identification card and the underground precise positioning base station based on the data signal sent by the same smart positioning identification card, and then obtain the location data of the coal miner in the mine. The smart positioning identification card periodically detects the strength of the ground satellite signal and the underground precise positioning base station signal. When it is detected that the ground satellite signal strength is lower than the first threshold, and the underground precise positioning base station signal is higher than the second threshold, it is determined that the coal miner has entered the underground from the ground, and the communication between the smart positioning identification card and the underground precise positioning base station is first started, and then the communication between the smart positioning identification card and the satellite is disconnected; When it is detected that the signal of the underground precise positioning base station is lower than the third threshold, and the ground satellite signal strength is higher than the fourth threshold, it is determined that the coal miner has come to the ground from the mine, and the communication between the smart positioning identification card and the satellite is first started, and then the communication between the smart positioning identification card and the underground precise positioning base station is disconnected.

2. The coal miner health big data platform system based on the mining smart positioning bracelet as claimed in claim 1 is characterized in that: The data statistical analysis module includes a data classification unit, a data analysis unit, and a health warning unit; A data classification unit, used for classifying according to body temperature data, heart rate data, motion data and location data; The data analysis unit is used to comprehensively analyze the body temperature data, heart rate data and exercise data of the coal miners, generate a health analysis table, and obtain the original health big data of the mining smart positioning bracelet from the database module, and compare the health big data with the data in the health analysis table to determine whether the health status of the coal miners is abnormal; The health warning unit is used to conduct health risk assessments when coal miners are in abnormal health conditions, determine the health risk level, and generate guidance plans of corresponding levels to push to coal miners; When the health status level exceeds the threshold, the location data of the coal miner is obtained, and an emergency call message is generated and pushed to the monitoring personnel.

3. The coal miner health big data platform system based on the mining smart positioning bracelet as claimed in claim 2 is characterized in that: The data display module includes: The temperature data display unit is used to display the daily temperature data in the form of a line chart, where the horizontal axis is time and the vertical axis is temperature, with hours as the horizontal axis unit and the highest temperature in the unit time as the vertical axis corresponding temperature value; The heart rate data display unit is used to display the daily heart rate data in the form of a line chart, where the horizontal axis is time and the vertical axis is heart rate, with hours as the horizontal axis unit and the average heart rate per unit time as the vertical axis corresponding heart rate value; The exercise data display unit is used to display the weekly exercise data in the form of a line chart, where the horizontal axis is time and the vertical axis is the number of steps, with days as the horizontal axis unit and the cumulative number of steps per unit time as the corresponding step value on the vertical axis; The location data display unit is used to display the location data of the current time point and the set time period in the form of a line chart, and form a historical trajectory and a personnel heat distribution map within the set time period; the location data is the horizontal and vertical coordinate points of the coal miner's location.

4. The coal miner health big data platform system based on the mining smart positioning bracelet as claimed in claim 3 is characterized in that: The database module uses a connection pool of MySQL version 5.7 or above, including 10 sub-databases; The database module establishes associations between various tables based on user accounts. The user table stores passwords and user account fields, the temperature data table stores user accounts, time and temperature fields, the heart rate data table stores user accounts, time and heart rate fields, the exercise data table stores user accounts, time and step number fields, the location data table stores user accounts, time and location data fields, and the health status analysis table stores user accounts, time and physiological indicator fields, where the physiological indicators are comprehensive data of body temperature, heart rate and step number.

5. The coal miner health big data platform system based on the mining smart positioning bracelet as claimed in claim 4 is characterized in that: The data query module uses the Django 2.0 or higher version of the Web framework to connect to the connection pool of the database module; The data query module includes a user login unit, a body temperature data query unit, a heart rate data query unit, a motion data query unit, and a location data query unit; The user login unit is used to obtain the user login account and password, query the corresponding password from the user table with the user login account as the primary key, and allow the user to log in if the two passwords are consistent; The temperature data query unit is used to query the corresponding temperature data from the temperature data table based on the user's temperature query request after the user logs in, using the user account and time as the primary key; A heart rate data query unit is used to query the corresponding heart rate data from the heart rate data according to the user's heart rate query request after the user logs in, using the user account and time as the main key; A sports data query unit, which is used to query sports data from a sports data table based on a user's sports data query request after the user logs in, using the user account and time as primary keys; The location data query unit is used to query the location data from the location data table based on the user's location data query request after the user logs in, using the user account and time as the primary key.

6. The coal miner health big data platform system based on the mining smart positioning bracelet as claimed in claim 1 is characterized in that: Ground communications equipment also includes uninterruptible power supplies; The uninterruptible power supply is connected to the core switch, wellhead switch, various ground switches and various ground wireless base stations; Underground communication equipment includes mine-use flameproof and intrinsically safe uninterruptible power supply; The mine-use flameproof and intrinsically safe uninterruptible power supply is connected to both the underground precise positioning base station and the underground wireless base station.

Images