CN116347380A - A LoRaWAN-based data acquisition system and acquisition method - Google Patents

A LoRaWAN-based data acquisition system and acquisition method Download PDF

Info

Publication number
CN116347380A
CN116347380A CN202310253791.8A CN202310253791A CN116347380A CN 116347380 A CN116347380 A CN 116347380A CN 202310253791 A CN202310253791 A CN 202310253791A CN 116347380 A CN116347380 A CN 116347380A
Authority
CN
China
Prior art keywords
data
value
sensor
data acquisition
lorawan
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310253791.8A
Other languages
Chinese (zh)
Inventor
张成挺
钱杰
黎勇
王文娟
陈立锋
余数
王柳婧
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Tobacco Zhejiang Industrial Co Ltd
Original Assignee
China Tobacco Zhejiang Industrial Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by China Tobacco Zhejiang Industrial Co Ltd filed Critical China Tobacco Zhejiang Industrial Co Ltd
Priority to CN202310253791.8A priority Critical patent/CN116347380A/en
Publication of CN116347380A publication Critical patent/CN116347380A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04W—WIRELESS COMMUNICATION NETWORKS
    • H04W4/00—Services specially adapted for wireless communication networks; Facilities therefor
    • H04W4/30—Services specially adapted for particular environments, situations or purposes
    • H04W4/38—Services specially adapted for particular environments, situations or purposes for collecting sensor information
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L49/00—Packet switching elements
    • H04L49/35—Switches specially adapted for specific applications
    • H04L49/354—Switches specially adapted for specific applications for supporting virtual local area networks [VLAN]
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/01—Protocols
    • H04L67/12—Protocols specially adapted for proprietary or special-purpose networking environments, e.g. medical networks, sensor networks, networks in vehicles or remote metering networks
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04W—WIRELESS COMMUNICATION NETWORKS
    • H04W84/00—Network topologies
    • H04W84/02—Hierarchically pre-organised networks, e.g. paging networks, cellular networks, WLAN [Wireless Local Area Network] or WLL [Wireless Local Loop]
    • H04W84/10—Small scale networks; Flat hierarchical networks
    • H04W84/12—WLAN [Wireless Local Area Networks]
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04W—WIRELESS COMMUNICATION NETWORKS
    • H04W88/00—Devices specially adapted for wireless communication networks, e.g. terminals, base stations or access point devices
    • H04W88/16—Gateway arrangements
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D30/00—Reducing energy consumption in communication networks
    • Y02D30/70—Reducing energy consumption in communication networks in wireless communication networks

Landscapes

  • Engineering & Computer Science (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • Signal Processing (AREA)
  • Health & Medical Sciences (AREA)
  • Computing Systems (AREA)
  • General Health & Medical Sciences (AREA)
  • Medical Informatics (AREA)
  • Arrangements For Transmission Of Measured Signals (AREA)

Abstract

A data acquisition system based on LoRaWAN comprises a factory level network, a switch and a data acquisition device, wherein the data acquisition device is provided with a LoRa communication module, and an acquisition signal output end of the data acquisition device is communicated with a LoRaWAN gateway through the LoRa communication module; the LoRaWAN gateway is connected with a switch, and the switch is connected with a factory level network; the factory-level network is respectively connected with the gateway server, the database server and the data monitoring terminal; the gateway server processes the acquisition signals sent by the data acquisition device through a data acquisition platform program; the database server stores and monitors the processed data, and if abnormal data is monitored, the abnormal data is transmitted to the data transmission monitoring terminal. The invention also provides a data acquisition system acquisition method based on the LoRaWAN. The invention has the advantages of convenient and accurate data acquisition, reduced labor cost and improved data acquisition efficiency.

Description

LoRaWAN-based data acquisition system and acquisition method
Technical Field
The invention relates to the technical field of factory monitoring, in particular to a data acquisition system and method based on LoRaWAN.
Background
Along with the improvement of production management requirements, various types of data collectors are required to be deployed in a cigarette production field, comprehensive safety production data are collected for decision management, and management efficiency of business departments is improved. At present, the factory area is provided with different areas such as an office area, a combined factory, a raw material auxiliary material circulating warehouse, a tobacco mellowing warehouse, a power center, a sewage treatment station, a lubrication station, an outdoor water tank and the like, the operation and maintenance management of the park relates to dozens of different operation and maintenance devices, and the number of operation and maintenance data generated every day is tens of thousands. Based on the requirements of park safety operation and maintenance management, certain important operation and maintenance data, such as pool liquid level data, fire pressure data, water quality and the like, must be monitored in real time. However, the existing data detection still adopts a manual timing inspection mode, which lacks an automation level, operation and maintenance management personnel must inspect repeatedly every day, which is time-consuming and labor-consuming, inaccurate in data recording, untimely in updating and easy in information lag.
Disclosure of Invention
In order to overcome the problems, the invention provides a data acquisition system and a data acquisition method based on LoRaWAN.
The first aspect of the invention provides a data acquisition system based on LoRaWAN, which comprises a factory level network, a switch and a data acquisition device, wherein the data acquisition device is provided with a LoRa communication module, and an acquisition signal output end of the data acquisition device is communicated with a LoRaWAN gateway through the LoRa communication module; the LoRaWAN gateway is connected with a switch, and the switch is connected with a factory level network;
the plant-level network is respectively connected with the gateway server, the database server and the data monitoring terminal; the gateway server sets a data acquisition platform program, processes acquisition signals sent by the data acquisition device through the data acquisition platform program, and transmits the processed data to the database server through the factory-level network; the database server stores and monitors the processed data, and if abnormal data is monitored, the abnormal data is transmitted to the data transmission monitoring terminal; the data monitoring terminal displays the abnormal data and gives an alarm.
Further, the LoRa communication module uses an SX1278 spread spectrum chip, the SX1278 spread spectrum chip is connected with a circuit through a pin header, wherein a VCC pin is connected with a 3.3V power supply, a GND pin is grounded, a RXD pin is connected with a TXD pin of an external MCU, the TXD pin is connected with the RXD pin of the external MCU, and when the SX1278 spread spectrum chip is in a communication mode, an AUX pin is set to be 0 to be disconnected, and an MD0 pin is set to be 0 to be disconnected.
Further, the data collector comprises a pressure sensor, a liquid level sensor, a water temperature sensor, a pH sensor, a TDS sensor and a turbidity sensor.
A second aspect of the present invention provides a method for collecting a data collection system based on a lorewan, including the steps of:
(1) Collecting data; the data acquisition device acquires 10 groups of data according to the acquisition frequency in 5-15 minutes; the 10 groups of data are transmitted to a LoRaWAN gateway by a LoRa communication module through a LoRaWAN protocol, and the LoRaWAN gateway is transmitted to a gateway server through a switch and a factory level network;
(2) Processing the data; the gateway server carries out average processing on 10 groups of data through a data acquisition platform program to obtain corresponding average values, then corrects the corresponding data according to the average values to obtain accurate acquisition data,
(3) Storing and monitoring data; and transmitting the acquired data to a database server from a factory-level network, wherein the database server stores the data on one hand, monitors the data on the other hand, and if abnormal data occurs, backtracking the data, transmitting the monitored abnormal data to a data monitoring terminal, and sending an alarm by the data monitoring terminal.
Further, the data acquisition platform program comprises:
(1) Averaging; acquiring single data, wherein the single data refers to that a data acquisition device acquires 10 times of data, and then carrying out average processing on the 10 times of data;
(2) The correction process specifically includes:
(2.1) temperature compensation processing of the TDS value, wherein the temperature compensation formula of the TDS value is as follows:
T correction ＝1+0.02×(T Testing -25) (1)
V Correction ＝T Correction ×V Testing (2)
Figure BDA0004128795720000031
Wherein T is Testing Representing the actual water temperature acquired by the water temperature sensor; t (T) Correction The corrected water temperature; v (V) Testing A voltage value output by the TDS sensor; v (V) Correction Correction values for the voltage output by the TDS sensor; TDS is a TDS value after temperature compensation;
(2.2) temperature compensation treatment on pH value, wherein the temperature compensation formula of the pH value is as follows:
pH＝-5.8287×P measuring +16.799 (4)
Wherein P is Measuring The pH value is the pH value after temperature compensation and is the voltage value output by the pH sensor;
(2.3) temperature compensation treatment of turbidity value, wherein the temperature compensation of turbidity value is to calculate voltage difference value caused by temperature difference, and the temperature compensation formula of turbidity value is as follows:
ΔU＝-0.0192×(T testing -25) (5)
Wherein DeltaU is the voltage difference, T Testing The actual water temperature obtained by the water temperature sensor;
secondly, calculating a compensation value from the voltage value of the turbidity standard liquid:
N＝865.68×(U-ΔU) (6)
wherein U is a voltage value output by a turbidity sensor of the turbidity standard liquid; n is a compensation value;
finally, correcting to obtain a turbidity value calculation formula after temperature compensation:
TU＝-865.68×U testing +N (7)
Wherein TU is the turbidity value after temperature compensation, U Testing Is the voltage value output by the turbidity sensor.
The beneficial effects of the invention are as follows:
(1) The invention introduces the LoRaWAN communication mode on the basis of the existing plant-level network, so that the data acquired by the data acquisition device can be transmitted to the LoRaWAN gateway through the LoRaWAN protocol, and the arrangement of the data acquisition system can be rapidly carried out on the structure of the plant-level network without changing the mode that the LoRaWAN gateway is connected with the switch.
(2) The invention also provides a gateway server and a database server, wherein a data acquisition platform program can be arranged in the gateway server, the data acquired by the data acquisition device is processed through the data acquisition program so as to ensure the accuracy of the data, the processed data is transmitted to the database server through a factory-level network, and the processed data is stored and monitored in the database server.
(3) The invention carries out corresponding temperature compensation processing on the data acquired by the data acquisition device, so that the data acquired by the data acquisition device is more in line with the actual situation, and the problem of overlarge data deviation is avoided. Meanwhile, the invention is provided with the data monitoring terminal, the data monitoring terminal can receive the monitored data information of the data server, and can give an alarm to an operation and maintenance manager in real time if an abnormal situation occurs, so that quick response is formed.
Drawings
FIG. 1 is a schematic diagram of a data acquisition system of the present invention
FIG. 2 is a circuit diagram of a pH sensor;
fig. 3 is a display page diagram of the data monitoring terminal.
Detailed Description
The following description of the embodiments of the present invention will be made more apparent and fully hereinafter with reference to the accompanying drawings, in which some, but not all embodiments of the invention are shown. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In the description of the present invention, it should be noted that, as the terms "center," "upper," "lower," "left," "right," "vertical," "horizontal," "inner," "outer," and the like are used for convenience in describing the present invention and simplifying the description based on the azimuth or positional relationship shown in the drawings, it should not be construed as limiting the present invention, but rather should indicate or imply that the devices or elements referred to must have a specific azimuth, be constructed and operated in a specific azimuth. Furthermore, the terms "first," "second," "third," and the like, as used herein, are used for descriptive purposes only and are not to be construed as indicating or implying any relative importance.
In the description of the present invention, it should be noted that unless explicitly stated and limited otherwise, the terms "mounted," "connected," and "connected" should be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present invention will be understood in specific cases by those of ordinary skill in the art.
Referring to the drawings, a first embodiment of the invention provides a data acquisition system based on a LoRaWAN, which comprises a factory level network, a switch and a data acquisition unit, wherein the data acquisition unit is provided with a LoRa communication module, and an acquisition signal output end of the data acquisition unit is communicated with a LoRaWAN gateway through the LoRa communication module; the LoRaWAN gateway is connected with a switch, and the switch is connected with a factory level network;
the plant-level network is respectively connected with the gateway server, the database server and the data monitoring terminal; the gateway server sets a data acquisition platform program, processes acquisition signals sent by the data acquisition device through the data acquisition platform program, and transmits the processed data to the database server through the factory-level network; the database server stores and monitors the processed data, and if abnormal data is monitored, the abnormal data is transmitted to the data transmission monitoring terminal; the data monitoring terminal displays the abnormal data and gives an alarm.
In the embodiment of the invention, the LoRa communication module uses an SX1278 spread spectrum chip, the SX1278 spread spectrum chip is connected with a circuit through a pin header, wherein a VCC pin is connected with a 3.3V power supply, a GND pin is grounded, an RXD pin is connected with an external MCU TXD pin, the TXD pin is connected with an external MCU RXD pin, when the SX1278 spread spectrum chip is in a communication mode, an AUX pin is set to be 0 to be disconnected, and an MD0 pin is set to be 0 to be disconnected.
In the embodiment of the invention, the factory-level network is network transmission in a factory and comprises various Internet protocols of TCP, IPv4 and IPv 6; the factory level network is connected with a gateway server, a database server and a switch; the database server adopts an iHistory real-time database; the switch is connected with a LoRaWAN gateway; the standard capacity of the LoRaWAN gateway is 500-1000 access points, the sensitivity is-141 dBm@SF12dBm,8 uplink channels and 1 downlink channel are accepted; support the data back transmission of network port, communication frequency: 470-510 MHz and POE power supply.
In the embodiment of the invention, the LoRa communication module w is ATK-LORA-01, and the ATK-LORA-01 is a long-distance LORA wireless serial port module which is provided by ALIENTEK and has small volume, low power consumption and high performance, and the module supports various serial port baud rates, air speed and working modes by using an SX1278 spread spectrum chip, and has a transmission distance of 3km. The SX1278 spread spectrum chip is connected with a circuit through a pin header, wherein a VCC pin is connected with a 3.3V power supply, a GND pin is grounded, a RXD pin is connected with a TXD pin of an external MCU, the TXD pin is connected with the RXD pin of the external MCU, when the SX1278 spread spectrum chip is in a communication mode, an AUX pin is disconnected when 0 is set, an MD0 pin is disconnected when 0 is set, and a data collector can transmit data of the data to a LoRaWAN gateway through a LoRa communication module.
In an embodiment of the invention, the data collector comprises a pressure sensor, a liquid level sensor, a water temperature sensor, a pH sensor, a TDS sensor and a turbidity sensor. The pressure sensor measuring range is as follows: 0-1.6MPa, precision: 2% FS. The liquid level sensor measuring range is as follows: 0-5 meters; overpressure: 1.5 times full scale pressure, precision: 2% FS.
The water temperature sensor adopts a DS18B20 digital temperature sensor, and in order to ensure high sensitivity of the sensor, the water temperature sensor is filled with sealant with high heat conductivity coefficient, so that high sensitivity reading of the water temperature sensor is ensured, and temperature delay is reduced. The temperature sensor is single-wire-interface. The measuring temperature range is-55 ℃ to 125 ℃, and the accuracy can reach +/-0.5 ℃ in the range of-10 ℃ to 85 ℃. The output signal of the DS18B20 sensor is a digital signal, and the digital signal has the advantages of small volume, low hardware cost, strong anti-interference capability, high precision and the like. The DS18B20 sensor probe used in the invention is isolated by the heat shrinkage tube at each pin of the chip, prevents short circuit, seals the glue inside, can be waterproof and dampproof, can be powered by 3.0V to 5.5V, has adjustable resolution of 9-12 bits, is also suitable for on-site temperature measurement in extreme environment, and has a unique number, and the digital temperature sensor can be identified according to different numbers to determine the corresponding temperature sensor. The GND pin of the sensor is used for grounding, the DQ pin is used for input and output, the VDD pin is used for connecting a power supply, and the NC pin is suspended. The core components of DS18B20 include: the device comprises a 64-bit photoetching ROM, a temperature sensor, non-volatile temperature alarm sensors TH and TL and a configuration register. Because the DS18B20 sensor is packaged in the metal probe, the temperature of the obtained liquid can be accurately measured, and the short circuit caused by direct contact between the sensor and the liquid is avoided.
The PH sensor is divided into a PH electrode and a PH module, the PH electrode is used for detecting, and the PH module is used for amplifying signals. Amplifying and converting the mv signal output by the electrode into a voltage signal of 0-5V. And then, voltage reading is carried out, and the output voltage signal is converted into the pH value of the solution to be detected according to a standard curve. The pH value measuring electrode consists of an indicating electrode and a reference electrode, wherein the indicating electrode is a glass electrode which is one of membrane electrodes, and the lower end of the glass electrode is a sensitive film formed by melting and blowing sodium glass or lithium glass with a hydrogen function. The glass electrode has a wide measuring range, including the whole range of pH value 0-14, and the working temperature span is in a larger range of-10-50 ℃, so that the glass electrode can be suitable for a common normal working environment. The corresponding time of the sensor is less than 5S, the stabilizing time is less than 60S, the power consumption of the element is less than 0.5W, and the service life can reach 3 years.
The turbidity sensor module comprehensively judges the turbidity condition of the water body according to the light transmittance and the scattering rate of the solution by utilizing an optical principle, the sensor is used for obtaining the turbidity of the water to be measured by utilizing an infrared correlation tube in the sensor, the light transmittance is used for determining the turbidity degree of the water to be measured, the current signal output by the sensor is used for converting the light transmittance into a voltage signal, and then the voltage signal is processed by AD conversion data, wherein the analog quantity can be sampled through an A/D converter of the singlechip to obtain the turbidity of the water to be measured. When the turbidity of the measured water exceeds a threshold value, an indicator lamp in the module is lightened, and the singlechip can judge whether the turbidity of the water exceeds the standard by monitoring the change of the level. The module has low price, convenient use and high measurement accuracy, can measure the water pollution degree of domestic water, is also suitable for monitoring industrial production sewage and environmental sewage, can measure 0NTU-1000NTU, and has a measurement error of +/-30 NTU. The turbidity sensor used needs to be careful that the top end of the turbidity sensor is not waterproof, the sensor burns out when the water surface exceeds the joint of the top cover and the shell, and the wavelength range of light received by the photosensitive diode of the sensor is (500-1050 nm), so that sunlight can influence the receiving of the photosensitive resistor of the sensor, the measurement output is influenced, and the direct irradiation of light is avoided when the sensor is used.
The TDS sensor module mainly measures the total dissolved substances in water, and the sensor is divided into a TDS probe and a sensor module. The TDS detection device conventionally used is simple but cannot transmit water quality data, so that continuous on-line monitoring is performed, and professional instruments are expensive. The TDS measurement range of the sensor is 0-1000ppm, and the measurement precision is + -5% F S (25 ℃). The module is compatible with 5V and 3.3V control systems, and can be connected into other control systems in series for relevant water quality measurement. The alternating current signal adopted in the measuring process is used as an excitation source, so that the polarization of the detection probe can be effectively prevented, the service life of the TDS probe is prolonged, and the stability of the output signal of the sensor is also improved. The TDS probe is a waterproof probe, can be immersed in water for a long time for measurement, and can be applied to water quality detection in the fields of lakes, rivers and the like, but the probe cannot be used for measuring liquid with overhigh temperature, and the probe cannot be placed too close to the edge of a container, otherwise, the measurement is affected.
A second embodiment of the present invention provides an acquisition method of a data acquisition system based on a lorewan, including the steps of:
(1) Collecting data; the data acquisition device acquires 10 groups of data according to the acquisition frequency in 5-15 minutes; the 10 groups of data are transmitted to a LoRaWAN gateway by a LoRa communication module through a LoRaWAN protocol, and the LoRaWAN gateway is transmitted to a gateway server through a switch and a factory level network;
(2) Processing the data; the gateway server carries out average processing on 10 groups of data through a data acquisition platform program to obtain corresponding average values, then corrects the corresponding data according to the average values to obtain accurate acquisition data,
(3) Storing and monitoring data; and transmitting the acquired data to a database server from a factory-level network, wherein the database server stores the data on one hand, monitors the data on the other hand, and if abnormal data occurs, backtracking the data, transmitting the monitored abnormal data to a data monitoring terminal, and sending an alarm by the data monitoring terminal.
In an embodiment of the present invention, the data acquisition platform program includes:
(1) Averaging; acquiring single data, wherein the single data refers to that a data acquisition device acquires 10 times of data, and then carrying out average processing on the 10 times of data;
(2) Because the temperature of each water quality data in the acquisition process is different, and the standard built-in sensor is a standard curve at 25 ℃, the TDS value, the pH value and the turbidity value are required to be compared with the data of the standard temperature, and the accuracy and the standardization of detection are ensured. The correction process specifically includes:
(2.1) temperature compensation processing of the TDS value, wherein the temperature compensation formula of the TDS value is as follows:
T correction ＝1+0.02×(T Testing -25) (1)
V Correction ＝T Correction ×V Testing (2)
Figure BDA0004128795720000101
Wherein T is Testing Representing the actual water temperature acquired by the water temperature sensor; t (T) Correction The corrected water temperature; v (V) Testing A voltage value output by the TDS sensor; v (V) Correction Correction values for the voltage output by the TDS sensor; TDS is a TDS value after temperature compensation;
(2.2) temperature compensation treatment on pH value, wherein the temperature compensation formula of the pH value is as follows:
pH＝-5.8287×P measuring +16.799 (4)
Wherein P is Measuring The pH value is the pH value after temperature compensation and is the voltage value output by the pH sensor;
(2.3) temperature compensation treatment of turbidity value, wherein the temperature compensation of turbidity value is to calculate voltage difference value caused by temperature difference, and the temperature compensation formula of turbidity value is as follows:
ΔU＝-0.0192×(T testing -25) (5)
Wherein DeltaU is the voltage difference, T Testing The actual water temperature obtained by the water temperature sensor;
secondly, calculating a compensation value from the voltage value of the turbidity standard liquid:
N＝865.68×(U-ΔU) (6)
wherein U is a voltage value output by a turbidity sensor of the turbidity standard liquid; n is a compensation value;
finally, correcting to obtain a turbidity value calculation formula after temperature compensation:
TU＝-865.68×U testing +N (7)
Wherein TU is the turbidity value after temperature compensation, U Testing Is the voltage value output by the turbidity sensor.
In summary, the invention introduces the LoRaWAN communication mode based on the existing plant-level network, so that the data collected by the data collector can be transmitted to the LoRaWAN gateway through the LoRaWAN protocol, and the arrangement of the data collection system can be rapidly carried out on the structure of the plant-level network without changing the mode that the LoRaWAN gateway is connected with the switch. The invention also provides a gateway server and a database server, wherein a data acquisition platform program can be arranged in the gateway server, the data acquired by the data acquisition device is processed through the data acquisition program so as to ensure the accuracy of the data, the processed data is transmitted to the database server through a factory-level network, and the processed data is stored and monitored in the database server. The invention carries out corresponding temperature compensation processing on the data acquired by the data acquisition device, so that the data acquired by the data acquisition device is more in line with the actual situation, and the problem of overlarge data deviation is avoided. Meanwhile, the invention is provided with the data monitoring terminal, the data monitoring terminal can receive the monitored data information of the data server, and can give an alarm to an operation and maintenance manager in real time if an abnormal situation occurs, so that quick response is formed.
The embodiments described in the present specification are merely examples of implementation forms of the inventive concept, and the scope of protection of the present invention should not be construed as being limited to the specific forms set forth in the embodiments, and the scope of protection of the present invention and equivalent technical means that can be conceived by those skilled in the art based on the inventive concept.

Claims (5)

1. The utility model provides a data acquisition system based on LoRaWAN, includes factory level network, switch and data collector, its characterized in that: the data acquisition device is provided with a LoRa communication module, and an acquisition signal output end of the data acquisition device is communicated with the LoRaWAN gateway through the LoRa communication module; the LoRaWAN gateway is connected with a switch, and the switch is connected with a factory level network;
the plant-level network is respectively connected with the gateway server, the database server and the data monitoring terminal; the gateway server sets a data acquisition platform program, processes acquisition signals sent by the data acquisition device through the data acquisition platform program, and transmits the processed data to the database server through the factory-level network; the database server stores and monitors the processed data, and if abnormal data is monitored, the abnormal data is transmitted to the data transmission monitoring terminal; the data monitoring terminal displays the abnormal data and gives an alarm.
2. A data acquisition system based on a LoRaWAN as claimed in claim 1, wherein: the LoRa communication module uses an SX1278 spread spectrum chip, the SX1278 spread spectrum chip is connected with a circuit through a pin header, wherein a VCC pin is connected with a 3.3V power supply, a GND pin is grounded, an RXD pin is connected with an external MCU TXD pin, the TXD pin is connected with an external MCU RXD pin, when the SX1278 spread spectrum chip is in a communication mode, an AUX pin is set to be 0 to be disconnected, and an MD0 pin is set to be 0 to be disconnected.
3. A data acquisition system based on a LoRaWAN as claimed in claim 1, wherein: the data collector comprises a pressure sensor, a liquid level sensor, a water temperature sensor, a pH sensor, a TDS sensor and a turbidity sensor.
4. A method of acquisition using a lorewan-based data acquisition system according to any of claims 1 to 3, comprising the steps of:
(1) Collecting data; the data acquisition device acquires 10 groups of data according to the acquisition frequency in 5-15 minutes; the 10 groups of data are transmitted to a LoRaWAN gateway by a LoRa communication module through a LoRaWAN protocol, and the LoRaWAN gateway is transmitted to a gateway server through a switch and a factory level network;
(2) Processing the data; the gateway server carries out average processing on 10 groups of data through a data acquisition platform program to obtain corresponding average values, then corrects the corresponding data according to the average values to obtain accurate acquisition data,
(3) Storing and monitoring data; and transmitting the acquired data to a database server from a factory-level network, wherein the database server stores the data on one hand, monitors the data on the other hand, and if abnormal data occurs, backtracking the data, transmitting the monitored abnormal data to a data monitoring terminal, and sending an alarm by the data monitoring terminal.
5. The acquisition method of claim 1, wherein the data acquisition platform program comprises:
(1) Averaging; acquiring single data, wherein the single data refers to that a data acquisition device acquires 10 times of data, and then carrying out average processing on the 10 times of data;
(2) The correction process specifically includes:
(2.1) temperature compensation processing of the TDS value, wherein the temperature compensation formula of the TDS value is as follows:
T correction ＝1+0.02×(T Testing -25) (1)
V Correction ＝T Correction ×V Testing (2)
Figure QLYQS_1
Wherein T is Testing Representing the actual water temperature acquired by the water temperature sensor; t (T) Correction The corrected water temperature; v (V) Testing A voltage value output by the TDS sensor; v (V) Correction Correction values for the voltage output by the TDS sensor; TDS is a TDS value after temperature compensation;
(2.2) temperature compensation treatment on pH value, wherein the temperature compensation formula of the pH value is as follows:
pH＝-5.8287×P measuring +16.799 (4)
Wherein P is Measuring The pH value is the pH value after temperature compensation and is the voltage value output by the pH sensor;
(2.3) temperature compensation treatment of turbidity value, wherein the temperature compensation of turbidity value is to calculate voltage difference value caused by temperature difference, and the temperature compensation formula of turbidity value is as follows:
ΔU＝-0.0192×(T testing -25) (5)
Wherein DeltaU is the voltage difference, T Testing The actual water temperature obtained by the water temperature sensor;
secondly, calculating a compensation value from the voltage value of the turbidity standard liquid:
N＝865.68×(U-ΔU) (6)
wherein U is a voltage value output by a turbidity sensor of the turbidity standard liquid; n is a compensation value;
finally, correcting to obtain a turbidity value calculation formula after temperature compensation:
TU＝-865.68×U testing +N (7)
Wherein TU is the turbidity value after temperature compensation, U Testing Is the voltage value output by the turbidity sensor.
CN202310253791.8A 2023-03-16 2023-03-16 A LoRaWAN-based data acquisition system and acquisition method Pending CN116347380A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310253791.8A CN116347380A (en) 2023-03-16 2023-03-16 A LoRaWAN-based data acquisition system and acquisition method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310253791.8A CN116347380A (en) 2023-03-16 2023-03-16 A LoRaWAN-based data acquisition system and acquisition method

Publications (1)

Publication Number Publication Date
CN116347380A true CN116347380A (en) 2023-06-27

Family

ID=86888853

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310253791.8A Pending CN116347380A (en) 2023-03-16 2023-03-16 A LoRaWAN-based data acquisition system and acquisition method

Country Status (1)

Country Link
CN (1) CN116347380A (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102004077A (en) * 2010-10-08 2011-04-06 中国农业大学 Turbidity transducer
CN107132329A (en) * 2017-06-27 2017-09-05 福建强闽信息科技有限公司 A kind of LoRaWAN multi-parameter water qualities on-line monitoring system and method
CN210223030U (en) * 2019-09-27 2020-03-31 禹云环境科技(广州)有限责任公司 Acquisition transmission system based on loRa and HMI gateway
US20200112386A1 (en) * 2018-10-04 2020-04-09 Fraunhofer-Gesellschaft Zur Foerderung Der Angewandten Forschung E.V. Concept for the analysis of a radio communication system
CN113110211A (en) * 2021-04-29 2021-07-13 南京工程学院 Distributed water quality remote monitoring system and monitoring method for aquaculture fishery
CN115266708A (en) * 2022-07-25 2022-11-01 交通运输部天津水运工程科学研究所 Embedded sand content measuring system based on recurrent neural network and control method

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN102004077A (en) * 2010-10-08 2011-04-06 中国农业大学 Turbidity transducer
CN107132329A (en) * 2017-06-27 2017-09-05 福建强闽信息科技有限公司 A kind of LoRaWAN multi-parameter water qualities on-line monitoring system and method
US20200112386A1 (en) * 2018-10-04 2020-04-09 Fraunhofer-Gesellschaft Zur Foerderung Der Angewandten Forschung E.V. Concept for the analysis of a radio communication system
CN210223030U (en) * 2019-09-27 2020-03-31 禹云环境科技(广州)有限责任公司 Acquisition transmission system based on loRa and HMI gateway
CN113110211A (en) * 2021-04-29 2021-07-13 南京工程学院 Distributed water quality remote monitoring system and monitoring method for aquaculture fishery
CN115266708A (en) * 2022-07-25 2022-11-01 交通运输部天津水运工程科学研究所 Embedded sand content measuring system based on recurrent neural network and control method

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
张冠雄等: "水产养殖无线数据采集监控系统", 福建电脑, 30 April 2016 (2016-04-30), pages 37 - 38 *

Similar Documents

Publication Publication Date Title
CN101782567B (en) Intelligent ammonia nitrogen transmitting system and ammonia nitrogen in situ high-frequency detection method
CN102156183B (en) Multi-parameter integrated COD (Chemical Oxygen Demand) water quality monitoring method
CN113566707B (en) Photosensitive measuring pin, system and online correction method for measuring pin sunlight angle
CN115790759A (en) Metering module of ultrasonic gas meter and metering method of ultrasonic gas meter
CN115308388B (en) A method for predicting mass concrete strength based on LoRa
CN115200748B (en) State measurement control system based on intelligent electronic thermometer
CN206990439U (en) A kind of new water turbidity detector based on NB IoT
CN210742233U (en) Simple multifunctional container
CN202916229U (en) Sulfur hexafluoride density micro-water monitoring device
CN203349869U (en) Henhouse environment wireless monitoring system
CN111829614A (en) Forecasting system based on 4G water level video identification
CN209671326U (en) A kind of hydraulic oil container Oil-temperature control system
CN110702735A (en) Residual chlorine electrode calibration method and water quality detection instrument
CN120405031B (en) On-line monitoring method and system based on water content of evaporative cooling medium
CN116347380A (en) A LoRaWAN-based data acquisition system and acquisition method
CN104535736A (en) On-line water-quality monitoring system for water reservoir
CN105353337A (en) Calibration method and device based on cloud computing
CN207923814U (en) A kind of portable air pollution object concentration monitor instrument
CN206832794U (en) A kind of LoRaWAN multi-parameter water qualities on-line monitoring system
CN216207030U (en) Optical signal measuring system based on reference light automatic compensation
CN114152333A (en) An optical signal measurement system based on differential comparison and compensation of reference light and reference light
CN115061223B (en) Intelligent forecasting system for west boundary flow
CN204944610U (en) A kind of pressure type water gauge adopting silicon capacitive pressure technology
CN206440714U (en) A kind of online soil testing assemblies
CN206097446U (en) Plant nutrient solution detecting system based on zigBee wireless technology

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination