Dataset: B-GOOD CO2 Gas Measurements

The dataset contains data from carbon dioxide gas measurements in five beehives over a period of 5 months at a distance of 11 seconds in 2022. The data was published by Bencsik MB, Chamberlain LC and Newton MN (TNTU) on the B-GOOD Bee Health Data Portal as part of the B-GOOD project (grant agreement 817622), funded under the EU Horizon 2020 Research and Innovation Programme.

The data was published by Bencsik MB, Chamberlain LC and Newton MN (TNTU) on the B-GOOD Bee Health Data Portal as part of the B-GOOD project (grant agreement 817622), funded under the EU Horizon 2020 Research and Innovation Programme. It contains data from carbon dioxide gas measurements in five beehives. The measurements were performed between 2022-07-08 and 2022-12-07 in most beehives, except for beehive 7 where measurements were performed between 2022-04-27 and 2022-09-25. In three beehives measurements came from two sensors, one placed near the queen excluder and one near the crown board. In beehive 7 only measurements from the sensor placed near the crown board was made available, even though in the description of the dataset the existence of a second sensor was mentioned. In beehive 1 only one sensor was used and it is not specified where the sensor was located.

The objectives of the B-GOOD project were: (1) Facilitate decision making for beekeepers and other stakeholders by establishing ready-to-use tools for operationalising the HSI; (2) Test, standardise and validate methods for measuring and reporting selected indicators affecting bee health; (3) Explore the various socio-economic and ecological factors beyond bee health; (4) Foster an EU community to collect and share knowledge related to honey bees and their environment; (5) Engender a lasting learning and innovation system (LIS); (6) Minimise the impact of biotic and abiotic stressors.

The dataset contains 8 files, each with aproximately 1.2 million records and a file size of approximately 70 MB. Each file is a merge of approximately 3380 single files from the same sensor on a given position in a given hive and each single file covers approximately one hour of measuremenmts.

Currently, the data integrated from the B-GOOD Bee Health Data Portal contains major issues and does not comply with the FAIR Guiding Principles for scientific data management and stewardship applied on the EU Pollinator Hub. More descriptive information about the context, quality and condition, or characteristics of the data (e.g. protocols, measurement devices used, units of the captured data, or any other details about the study) must be provided. More metadata in the form of accurate and relevant attributes (*e.g. *metadata that describes the scope of the data has been described, any particularities or limitations about the data that other users should be aware of, specification of the date of generation/collection of the data, the lab conditions, who prepared the data, the parameter settings, the name and version of the software used, specification of whether it is raw or processed data, explanation of all variable names are explained if they are not self-explanatory) must be provided. It requires major revisions by the data provider.

The data was published by Bencsik MB, Chamberlain LC and Newton MN (TNTU) on the B-GOOD Bee Health Data Portal as part of the B-GOOD project (grant agreement 817622), funded under the EU Horizon 2020 Research and Innovation Programme. The dataset contains data from carbon dioxide gas measurements in five beehives. The measurements were performed between 2022-07-08 and 2022-12-07 in most beehives, except for beehive 7 where measurements were performed between 2022-04-27 and 2022-09-25. In three beehives measurements came from two sensors, one placed near the queen excluder and one near the crown board. In beehive 7 only measurements from the sensor placed near the crown board was made available, even though in the description of the dataset the existence of a second sensor was mentioned. In beehive 1 only one sensor was used and it is not specified where the sensor was located.

The objectives of the B-GOOD project were: (1) Facilitate decision making for beekeepers and other stakeholders by establishing ready-to-use tools for operationalising the HSI; (2) Test, standardise and validate methods for measuring and reporting selected indicators affecting bee health; (3) Explore the various socio-economic and ecological factors beyond bee health; (4) Foster an EU community to collect and share knowledge related to honey bees and their environment; (5) Engender a lasting learning and innovation system (LIS); (6) Minimise the impact of biotic and abiotic stressors.

All raw data files were downloaded from the B-GOOD Bee Health Data Portal on 2024-07-04.

List of raw data obtained from the data provider.

1. Archive Istec.zip accessed on 2024-07-04 14:29:30, provided by B-GOOD Bee Health Data Portal
2. Archive Crown board.zip accessed on 2024-07-04 14:29:24, provided by B-GOOD Bee Health Data Portal
3. Archive Queen excluder.zip accessed on 2024-07-04 14:29:23, provided by B-GOOD Bee Health Data Portal
4. Archive Crown board.zip accessed on 2024-07-04 14:29:21, provided by B-GOOD Bee Health Data Portal
5. Archive Queen excluder.zip accessed on 2024-07-04 14:29:20, provided by B-GOOD Bee Health Data Portal
6. Archive Crown board.zip accessed on 2024-07-04 14:29:22, provided by B-GOOD Bee Health Data Portal
7. Archive Crown board.zip accessed on 2024-07-04 14:29:25, provided by B-GOOD Bee Health Data Portal
8. Archive Queen excluder.zip accessed on 2024-07-04 14:29:28, provided at B-GOOD Bee Health Data Portal

Metadata was obtained from the web pages of the single datasets (see above).

All files in the zip-archives were extracted using File Explorer (Microsoft Corporation, version 22H2). Files from the same archive were merged using the python script MergeToCsv.py:

• Archive Istec.zip obtained from dataset CO2_Gas_Measurements_Hive_1_ISTEC contained 3401 files in csv format with a total of 1.190.029 records, recorded from 2022-07-08 11:50:50 to 2022-12-07 12:48:16, which were merged to file CO2GasMeasurementsHive1ISTEC.csv using thePython script MergeCsv.py.
• Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_5_HPP contained 3378 fieles in csv format with a total of 1.180.538 records, recorded from 2022-07-08 15:26:02 to 2022-12-06 12:42:17, which were merged to file CO2GasMeasurementsHive5HPPcrown board.csv using thePython script MergeCsv.py.
• Archive Queen excluder.zip obtained from dataset CO2_Gas_Measurements_Hive_5_HPP contained 3378 files in csv format with a total of 1.180.479 records, recorded from 2022-07-08 15:30:14 to 2022-12-06 12:47:57, which were merged to file CO2GasMeasurementsHive5HPPqueen excluder.csv using thePython script MergeCsv.py.
• Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_6_HPP contained 3377 files in csv format with a total of 1.180.413 records, recorded from 2022-07-08 15:20:47 to 2022-12-06 12:32:29, which were merged to file CO2_Gas_Measurements_Hive_6_HPP_crown board.csv using thePython script MergeCsv.py.
• Archive Queen excluder.zip obtained from dataset CO2_Gas_Measurements_Hive_6_HPP contained 3377 files in csv format with a total of 1.180.478 records, recorded from 2022-07-08 15:20:45 to 2022-12-06 12:32:24, which were merged to file CO2_Gas_Measurements_Hive_6_HPP_queen excluder.csv using thePython script MergeCsv.py.
• Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_7_HPP contained 3377 files in csv format with a total of 1.180.426 records, recorded from 2022-04-27 10:07:44 to 2022-09-25 08:19:09, which were merged to file CO2_Gas_Measurements_Hive_7_HPP_crown board.csv using thePython script MergeCsv.py.
• Archive Crown board.zip obtained from dataset CO2_Gas_Measurements_Hive_8_HPP contained 3377 files in csv format with a total of 1.180.374 records, recorded from 2022-07-08 16:11:56 to 2022-12-06 13:17:37, which were merged to file CO2_Gas_Measurements_Hive_8_HPP_crown board.csv using thePython script MergeCsv.py.
• Archive Queen excluder.zip obtained from dataset CO2_Gas_Measurements_Hive_8_HPP contained 3377 files in csv format with a total of 1.180.298 records, recorded from 2022-07-08 16:14:07 to 2022-12-06 13:17:46, which were merged to file CO2_Gas_Measurements_Hive_8_HPP_crown board.csv using thePython script MergeCsv.py.

The merged files were imported into a SQL database (MariaDB foundation, server version 10.4.32) running in an XAMPP environment (BitRock, version 5.2.1) according to the following workflow:

• UNIX timestamps in column time were transformed to ISO 8601 format and saved in column datetime using Query 1

Data was then exported to the respective preparatory files and uploaded to the EU Pollinator Hub according to SOP-017 (Dataset integration.

No data validation was performed.

No data analysis was performed.

UPDATE tablereference SET colname = FROM_UNIXTIME(colname);