Dataset: Pollination

Data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, inon economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops
Provided by:
Published: 2023-07-26
Compliance with FAIR* principles
Findable
Accessible
Interoperable
Reusable
See https://www.go-fair.org/fair-principles for more information about FAIR principles
Data Quality
Good
Data

Supplemental Files

Any supplemental files, not containing data.

Columns

Description File Details
Dataset Report
This file contains in detail the structure of the dataset.
This is a generated file.
Ecology.R
Results from data analysis.
Media type: Document
File size: 21.44 KiB
Ecology.pdf
Results from data analysis.
Media type: Document
File size: 311.30 KiB
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.
images.zip
Archive of images referred to in table [imagelist](https://app.pollinatorhub.eu/dataset-discovery/parts/PLLNT11.RFMGS80.0)
Media type: Document
File size: 43.26 MiB
About

Abstract

The dataset contains data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops.

Executive summary

Data overview

The dataset contains data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops.

Data value

The dataset allows linkage between plants, pollinating animals, and human economic activities.

Data description

The dataset contains 8 tables. Three tables provide a linkage between entities: Crop aggregate to single crop, single crop to plant species, pollinating insect to pollinated plant species. One table contains information on the economic impact of pollination on the economic value of crop production. Four tables contain references.

Data application

This data is suited for linking data from existing data hubs such as the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT), national databases containing data on agricultural production, beekeeping and pesticide use, the Global Biodiversity Information Facility (GBIF) as well as data from scientific and technical publications. Possible research questions include the following:

  1. What is the economic impact of pollination by animals on the economic value of crop production in a given area and a given year?
  2. What is the economic value of beehive products relative to the economic value of pollination by animals for crop production in a given area and a given year?
  3. What is the proportion of agricultural land requiring pollination by animals in the total agricultural land in a given area and a given year?
  4. What is the average number of beehives in an area per unit of agricultural land requiring pollination in a given area and a given year?
  5. Which animals are potential pollinators of a given crop or a given plant species in an area?
  6. Which pollinating insects are potentially threatened due to the application of plant protection products on a crop in an area?

Unresolved issues

n/a

Introduction

For a range of crops, pollinating insects are a crucial factor for productivity. Several databases for crop production and classification as well as animal and plant species taxonomy and occurrence exist. To our knowledge, however, there is no publicly available data hub, which allows direct linkage of crop production, plants, and insect pollinators. The currently available data in the dataset was obtained from professionally acquired and reviewed data sources such as the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT) and the Global Biodiversity Information Facility (GBIF) as well as data from scientific and technical publications. Works by Klein et al. (Klein, et al., 2007) and Gallai et al. (Gallai, Salle, Settele, & Vaissière, 2009) were used as theoretical basis for the economic importance of pollinators for world crops. The present data set is incomplete and intended to be a starting point for further work (data collection, standardisation and harmonisation) on this topic.

Material and methods

Data acquisition

Data from the Food and Agriculture Organization Corporate Statistical Database (FAOSTAT), the statistical data website of the Food and Agriculture Organization of the United Nations (FAO), was obtained on March 29, 2022. Later versions of the database are therefore not considered. Data from scientific literature and images were acquired manually. Data from FAO is made available under the Creative Commons Attribution-NonCommercial-ShareAlike 3.0 IGO license (CC BY-NC-SA 3.0 IGO; https://creativecommons.org/licenses/by-nc-sa/3.0/igo). In addition to this license, some database specific terms of use are listed: https://www.fao.org/contact-us/terms/db-terms-of-use/en/.

Data preparation

Raw data was rearranged and converted to CSV format using Excel (Microsoft Corporation, version 15.0.5293.1000) and subsequently imported for profiling into a MySQL database (Oracle Corporation) running in a XAMPP environment (BitRock, version 2.3.4). Data was exported from the MySQL database to CSV format using windows-1252 coding. Data for this dataset are stored CSV format. Three tables provide a linkage between entities: Crop aggregate to single crop (crop_aggregate), single crop to plant species (crop_species), pollinating insect to pollinated plant species (insect_plant). One table contains information on the economic impact of pollination on the economic value of crop production (pollination_dependency). Four tables contain specific references (ref_flag, ref_image, ref_source, ref_unit) used in this dataset. Data were explored using descriptive statistics. Metrics for selected key columns are reported.

Data validation

No data validation was performed.

Data analysis

Data analyses can be found in supplemental files Ecology.R and Ecology.pdf.

References

There are no sources in the current document.

Contributors

Data Providers

Reviewed by

Rubinigg Michael as Data scientist, San Martin Gilles as Data scientist
Discussion

Discussion (0)

Log in to comment!

Classifications
Analytical Capacities
Simple software

Simple software applications such as spreadsheets (Microsoft Excel, Apache OpenOffice Calc) are sufficient to analyse the data.

Regulatory Standards
None

No regulatory standard applied.

Technical Standards
None

No technical standard applied.

Issues
There are no known issues in this dataset.
Properties

Unique identifier

[PLLNT11.0.0]

EUPH IRI

https://app.pollinatorhub.eu/dataset-discovery/PLLNT11.0.0

Status

Quality Validated

Peer review

No peer review was requested.

DOI

No DOI available.

Published

2023-07-26

Access rights

Open
Citation
Michael Rubinigg 2023 Data on economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, inon economic dependence of pollination by animals in crops as well as observations of pollinators on plant species, in particular crops. EU Pollinator Hub. [2025-07-05] app.pollinatorhub.eu
Share
Contact
No public contact details available.
You need to login in order to be able to send a direct message to Author
Dataset rating
You need to be registered in order to give a rating. No ratings available yet.
Metrics

Total views

560

Total downloads

29