10.5281/zenodo.4953762
https://zenodo.org/records/4953762
oai:zenodo.org:4953762
Dupont Yoko L
Dupont Yoko L
Aarhus University, Denmark
Capela Nuno
Capela Nuno
Instituto do Ambiente Tecnologia e Vida, University of Coimbra, Portugal
Kryger Per
Kryger Per
Aarhus University, Denmark
Alves Joana
Alves Joana
Instituto do Ambiente Tecnologia e Vida, University of Coimbra, Portugal
Axelsen Jørgen A
Axelsen Jørgen A
Aarhus University, Denmark
Balslev Mette G
Balslev Mette G
Aarhus University, Denmark
Bruus Marianne
Bruus Marianne
Aarhus University, Denmark
Castro Silvia
Castro Silvia
Instituto do Ambiente Tecnologia e Vida, University of Coimbra, Portugal
Frederiksen Julie
Frederiksen Julie
Aarhus University, Denmark
Groom Geoff B
Groom Geoff B
Aarhus University, Denmark
Jeppesen Annika S
Jeppesen Annika S
Aarhus University, Denmark
Lichtenberg-Kraag Birgit
Lichtenberg-Kraag Birgit
Länderinstitut für Bienenkunde, Germany
Lopes Sara
Lopes Sara
Instituto do Ambiente Tecnologia e Vida, University of Coimbra, Portugal
Pinto M. Alice
Pinto M. Alice
Centro de Investigação de Montanha, Instituto Politécnico de Bragança, Portugal
Alves da Silva Antonio
Alves da Silva Antonio
Instituto do Ambiente Tecnologia e Vida, University of Coimbra, Portugal
Strandberg Beate
Strandberg Beate
Aarhus University, Denmark
Sørensen Peter Borgen
Sørensen Peter Borgen
Aarhus University, Denmark
Sousa José Paulo
Sousa José Paulo
Instituto do Ambiente Tecnologia e Vida, University of Coimbra, Portugal
Research project on field data collection for honey bee colony model evaluation - datasets
Zenodo
2021
landscape mapping
floral resources
population assessment
observation hive
pesticides exposure
flight activity
image analysis
2021-07-15
eng
10.2903/sp.efsa.2017.EN-1234
10.2903/sp.efsa.2021.EN-6695
10.2903/sp.efsa.2021.EN-6694
10.2903/sp.efsa.2016.EN-1069
10.2903/j.efsa.2021.6607
10.5281/zenodo.779880
10.5281/zenodo.4953761
https://zenodo.org/communities/efsa-kj
Creative Commons Attribution 4.0 International
A new version with coordinates has been added.
Please download the datasets uploaded under the new version using this link: https://doi.org/10.5281/zenodo.4953761
Description of the datasets
The file 00_MUSTB_field_data_model.docx contains the data model according to which the data collected in the context of the MUSTB field data collection were reported to EFSA. The current data model description includes some modifications with respect to the specifications published before the beginning of the project (EFSA, 2017, https://doi.org/10.2903/sp.efsa.2017.EN-1234). All the tables included in the data model are published here in csv format. The underlying schemas are also published in xsd format.
Sites: General information about the sites where the data collection took place;
Polygons: General information about the polygons where the botanical survey took place.
Table I: Pesticide application, reporting data on experimental spraying events;
Table II: Resource providing unit and landscape fitness, reporting data on abundance of flowering plants in polygons mostly within 1.5 km, but in some cases up to 3 km of the experimental colony;
Table III: Master list of all hives included in the study;
Table IV: Colony management, reporting the log of the beekeeper regarding input (if material was added to the hive: e.g. empty frames, chemicals for varroa treatment, sugar), output (if material was removed from the hive, e.g. honey combs, supers), queen loss, swarming, or clinical signs observed in the experimental hives;
Table V: Hive inspection, reporting data on in-hive measurements in the experimental colonies. This table contained several types of data, including:
Data on brood development and food provision (“cell utilization”) obtained from image analysis of combs;
Data on forager activity obtained from automatic video recordings and image analysis by a bee counter;
Data on hive weight obtained from automatic logging by a hive scale;
Data on adult bee strength, obtained by weight assessment of combs with and without adult bees (“bees per comb data”);
Table VI: SSD2, reporting data on results of laboratory analyses of pollen, pesticide residues and parasites/pathogens. These four types of laboratory analyses involved different methods, and were reported according to different standards. Therefore, a number of the fields in the technical specifications for the SSD2 table (EFSA, 2017) were not applicable for records reporting results of some analyses, in particular palynological, parasite and pathogen analyses. These fields were left empty;
Table VII: Colony observation, reporting observations of honey bee waggle dances from observation hives. Orientation denotes the angle of the waggling phase relative to the vertical axis on the comb. Direction denotes the actual direction in the landscape, as calculated from the orientation of the waggle dance.
In all the csv files, columns with the suffix "_desc" have been included, where relevant, to include the name corresponding to the EFSA controlled terminology used in the previous column (e.g. resUnit contains EFSA term codes while resUnit_desc contains the term names).
Data storage
All data collected during the project was stored in a relational database. The database was developed in .NET Entity Framework Core, ran on a PostgreSQL, and was hosted by Amazon Web Service during the whole duration of the project development. Data could be imported or entered manually in the database through a web form. Administrators could create new users and administrators, new sites, and new colonies, i.e., administrators were allowed to enter or change data of all tables. Users were allowed to enter data, and could view, retrieve, and modify their own data of all tables, except for Table III (description of experimental colonies). Administrators could view and retrieve all data. Data was retrieved in CSV and XML formats, and were structured to secure a smooth transmission of data to the Data Collection Framework of EFSA. Furthermore, data flow from the field data collection to the development of ApisRAM was secured by direct communication between the field and modelling teams.
EU; csv; data.collection@efsa.europa.eu