Dataset: B-GOOD WP3 Field Data
Dataset tables
| Table | Description | Rows | Data Points | Downloads |
|---|---|---|---|---|
Supplemental Files
Any supplemental files, not containing data.
| File Name | Description | File Details | ||
|---|---|---|---|---|
|
|
Dataset Report
|
This file contains in detail the structure of the dataset.
|
This is a generated file.
|
|
|
|
Licence
|
This file contains dataset licencing information.
|
This is a generated file.
|
|
|
|
Readme
|
The file contains basic information about the dataset.
|
This is a generated file.
|
Abstract
The dataset contains field data on floral resources from 3 locations in 2020-2021 in Belgium, Poirtugal and United Kingdom. It was published by Alves da Silva A, Lopes S, Parreira T, Castro S, Bouuaert DC, McVeigh A, Alves J, Sousa JP (UCOI) 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.
Executive summary
Data overview
The data was published by Alves da Silva A, Lopes S, Parreira T, Castro S, Bouuaert DC, McVeigh A, Alves J, Sousa JP (UCOI) 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 field data obtained from the implementation of the field protocols 1 (Assessment of plant species composition), 2 (Assessment of Phenology of Floral Resources), and 3 (Assessment and quantification of floral resources as well as flowering species characterization) in Belgium, Portugal and the United Kingdopm, developed under B-GOOD and described in Milestone MS15.
Data value
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.
Data description
Data application
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. Tha dataset requires major revisions by the data provider.
Unresolved issues
Introduction
Material and methods
Data acquisition
All raw data files were downloaded from the B-GOOD Bee Health Data Portal on 2024-09-26 18:16:28.
List of raw data obtained from the data provider.
- File field-data-protocol-1-be.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-1-pt.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-1-uk.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-2-be.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-2-pt.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-2-uk.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-3-part-1-be.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-3-part-1-pt.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-3-part-1-uk.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
- File field-data-protocol-3-part-2-be-pt-uk.xlsx, accessed on 2024-09-26 18:16:28, provided by B-GOOD Bee Health Data Portal
Metadata was obtained from the dataset's web page.
Data preparation
All files in the zip-archives were extracted using File Explorer (Microsoft Corporation, version 22H2).
Files field-data-protocol-1-be.xlsx, field-data-protocol-1-pt.xlsx and field-data-protocol-1-uk.xlsx were opened with MS Excel (Microsoft Corporation, version 2409). The worksheets were exported to data files in CSV format (UTF-8 encoding) and imported into Notepad++ (version 8.7) where missing values were substituted by {NULL} using regular expressions, decimal points were converted to a baseline dot using regular expression ((?<=\d),(?=\d) replaced with .) and the first row of each data file containing information related to the header row was transferred into as separate header file. The data file was unpivoted using the Python script UnpivotToCsv.py while the header file was rotated using the Python script TransposeCsv.py. The data in both files was subsequently merged using a SQL database (MariaDB foundation, server version 10.4.32) running in an XAMPP environment (BitRock, version 5.2.1).
Files field-data-protocol-2-be.xlsx, field-data-protocol-2-pt.xlsx and field-data-protocol-2-uk.xlsx were opened with MS Excel (Microsoft Corporation, version 2409). The worksheets were exported to data files in CSV format (UTF-8 encoding) and imported into Notepad++ (version 8.7) where missing values were substituted by {NULL} using regular expressions, decimal points were converted to a baseline dot using regular expression ((?<=\d),(?=\d) replaced with .) and the first 2 rows of each data file containing information related to the header row was transferred into as separate header file. The data file was unpivoted using the Python script UnpivotToCsv.py while the header file was rotated using the Python script TransposeCsv.py. Dates were parsed to the required YYYY-MM-DD format using the python script ParseDates.py. The data in both files was subsequently merged using a SQL database (MariaDB foundation, server version 10.4.32) running in an XAMPP environment (BitRock, version 5.2.1).
Files field-data-protocol-3-part-1-be.xlsx, field-data-protocol-3-part-1-pt.xlsx and field-data-protocol-3-part-1-uk.xlsx were opened with MS Excel (Microsoft Corporation, version 2409) where missing colums were added and the first rows of each data file containing information related to the header row was deleted, as it contained no information that was considered necesary to be included in the data file. The worksheets were exported to data files in CSV format (UTF-8 encoding) and imported into Notepad++ (version 8.7) where missing values were substituted by {NULL} using regular expressions, decimal points were converted to a baseline dot using regular expression ((?<=\d),(?=\d) replaced with .). Dates were parsed to the required YYYY-MM-DD format using the python script ParseDates.py.
File field-data-protocol-3-part-2-be-pt-uk.xlsx was opened with MS Excel (Microsoft Corporation, version 2409) where the first row containing information related to the header row was deleted, as it contained no information that was considered necesary to be included in the data file. The worksheet was exported to a data file in CSV format (UTF-8 encoding) and imported into Notepad++ (version 8.7) where missing values were substituted by {NULL} using regular expressions, decimal points were converted to a baseline dot using regular expression ((?<=\d),(?=\d) replaced with .).
Data was then exported to the respective preparatory files and uploaded to the EU Pollinator Hub according to SOP-017 (Dataset integration.
Data validation
No data validation was performed.
Data analysis
No data analysis was performed.
References
-
Alves da Silva A., Lopes S., Parreira T., Castro S., Bouuaert D., McVeigh A. et al. 2022 Field data obtained from the implementation of the Field Protocols 1, 2, and 3 from WP3. B-GOOD Bee Health Data Portal. [2024-10-30] beehealthdata.org
Reviewed by
Rubinigg Michael as Data scientist- For column Plant community it is unclear, which taxonomy (data standard) has been used for the attributes describing the various plant communities. The data provider is requested to make this information available.
- For column ID it is unclear, what the identifier refers to. The data provider is requested to make this information available.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column lifeform it is unclear, which taxonomy (data standard) has been used for the attributes describing the life form of a particular plant species. The data provider is requested to make this information available, if possible.
- For column value it is unclear, what the reported variable actually is and in which unit it is provided.
- For column Sampling it is unclear, what it contains. The data provider is requested to make this information available.
- For column Plant community it is unclear, which taxonomy (data standard) has been used for the attributes describing the various plant communities. The data provider is requested to make this information available.
- For column ID it is unclear, what the identifier refers to. The data provider is requested to make this information available.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column lifeform it is unclear, which taxonomy (data standard) has been used for the attributes describing the life form of a particular plant species. The data provider is requested to make this information available, if possible.
- For column value it is unclear, what the reported variable actually is and in which unit it is provided.
- For column Plant community it is unclear, which taxonomy (data standard) has been used for the attributes describing the various plant communities. The data provider is requested to make this information available.
- For column ID it is unclear, what the identifier refers to. The data provider is requested to make this information available.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column lifeform it is unclear, which taxonomy (data standard) has been used for the attributes describing the life form of a particular plant species. The data provider is requested to make this information available, if possible.
- For column value it is unclear, what the reported variable actually is and in which unit it is provided.
- For column Replica it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide a more precise information.
- For column Individual it is unclear what it describes. The data provider is requested to make this information available.
- For column Latitude it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Longitude it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Elevation it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column BBCH 60 it is unclear what it describes. The data provider is requested to make this information available.
- For column BBCH 65 it is unclear what it describes. The data provider is requested to make this information available.
- For column BBCH 69 it is unclear what it describes. The data provider is requested to make this information available.
- For column Sampling it is unclear what it describes. The data provider is requested to make this information available.
- For column value it is unclear, what the reported variable actually is and in which unit it is provided.
- For column Replica it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide a more precise information.
- For column Individual it is unclear what it describes. The data provider is requested to make this information available.
- For column Latitude it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Longitude it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Elevation it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column BBCH 60 it is unclear what it describes. The data provider is requested to make this information available.
- For column BBCH 65 it is unclear what it describes. The data provider is requested to make this information available.
- For column BBCH 69 it is unclear what it describes. The data provider is requested to make this information available.
- For column Sampling it is unclear what it describes. The data provider is requested to make this information available.
- For column value it is unclear, what the reported variable actually is and in which unit it is provided.
- For column Replica it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide a more precise information.
- For column Individual it is unclear what it describes. The data provider is requested to make this information available.
- For column Latitude it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Longitude it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Elevation it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide this information.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column BBCH 60 it is unclear what it describes. The data provider is requested to make this information available.
- For column BBCH 65 it is unclear what it describes. The data provider is requested to make this information available.
- For column BBCH 69 it is unclear what it describes. The data provider is requested to make this information available.
- For column Sampling it is unclear what it describes. The data provider is requested to make this information available.
- For column value it is unclear, what the reported variable actually is and in which unit it is provided.
- For column Sampling Polygon ID it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide a more precise information.
- For column Sampling Point ID it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sampling point LAT it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sampling point LONG it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Elevation (m) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Date it is may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column Plant habit (Layer) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information, in particular a reference to the nomenclature that has been used.
- For column Quadrat_PC it is unclear what it describes. The data provider is requested to make this information available.
- For column Plant cover (%) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information..
- For column Quadrat_FA it is unclear what it describes. The data provider is requested to make this information available.
- For column No Flowers it is unclear what it describes. The data provider is requested to make this information available.
- For column Area (m2) it is unclear what it describes. The data provider is requested to make this information available.
- For column Landscape window it is unclear what it contains. The data provider is requested to provide this information.
- For column Polygon ID it is unclear what it contains. The data provider is requested to provide this information.
- For column Polygon Type it is unclear what it contains. The data provider is requested to provide this information, in particular the nomenclature that has been used.
- For column Polygon Type_1 it is unclear what it contains. The data provider is requested to provide this information.
- For column Sampling Polygon ID it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide a more precise information.
- For column Sampling Point ID it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sampling point LAT it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sampling point LONG it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Elevation (m) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Date it is may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column Plant habit (Layer) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information, in particular a reference to the nomenclature that has been used.
- For column Quadrat_PC it is unclear what it describes. The data provider is requested to make this information available.
- For column Plant cover (%) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Flowering Plant cover (%) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Quadrat_FA it is unclear what it describes. The data provider is requested to make this information available.
- For column No Flowers it is unclear what it describes. The data provider is requested to make this information available.
- For column Area (m2) it is unclear what it describes. The data provider is requested to make this information available.
- For column Polygon Type it is unclear what it contains. The data provider is requested to provide this information, in particular the nomenclature that has been used.
- For column Sampling Polygon ID it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide a more precise information.
- For column Sampling Point ID it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sampling point LAT it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sampling point LONG it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Elevation (m) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Survey (7) it is unclear what it describes. The data provider is requested to make this information available.
- For column Month (March - September) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Date it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Species it is unclear, if a particular nomenclature has been used for the names of the species. The data provider is requested to make this information available, if possible.
- For column Plant habit (Layer) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information, in particulare a reference to the nomenclature that has been used.
- For column Quadrat_PC it is unclear what it describes. The data provider is requested to make this information available.
- For column Plant cover (%) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Quadrat_FA it is unclear what it describes. The data provider is requested to make this information available.
- For column No Flowers it is unclear what it describes. The data provider is requested to make this information available.
- For column Area (m2) it is unclear what it describes. The data provider is requested to make this information available.
- For column No. Plants sampled it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column No. of Anthers/flower it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column No. Of pollen grains/anther it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column No. Of pollen/flower it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column No. Of pollen/inflorescence it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column No. of flowers per flower cluster/catkin it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Number of samples it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Nectar volume/flowers (uL) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.
- For column Sugar concentration/flower (% Brix) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information. The data provider is also requested, which unit has been used (°Bx or %).
- For column Sugar concentration/flower (ug) it may be guessed, but it is not explicitly stated what it describes. The data provider is requested to provide more information.