An implementation of a real-time water quality monitoring IoT system with 4G connectivity : Catfish - Data and Sensors

Abstract: This report is about implementing an Internet of Things (IoT) system that is meant to measure the water quality of the Nissan river located in Halmstad. The system measures the temperature, pH value, turbidity, dissolved oxygen, total dissolved solids and electrical conductivity of the water. The project is named Catfish, and the authors of the report are in the Data and Sensors team. The purpose of the Data and Sensors team is to program the prototype to collect the specified environmental values, combining all functionalities of the prototype in the main code, and sending the data wirelessly to a database in real-time, including creating the database. To collect the data, two Arduino microcontrollers and sensors from DFRobot are used. For the central computing, a Raspberry Pi is used. To send the data in real-time, a 4G dongle is connected to the Raspberry Pi and to transmit the data, the protocol TCP/IP is used. In order to create a local database, SQLite is used, and for the database server, MariaDB is used. The project has succeeded to collect data from the specified sensors, send the data wirelessly over the Internet with the help of a 4G modem, and store the data in a database on a remote temporary server. However, the sensors are not calibrated due to lack of time, which means the data received from the sensors can not be trusted. The server that stores the data is a temporary server implemented by the Data and Sensors team since there was no other place to store the data.