Dataset: Pollination
Dataset tables
Description | Data Points | Downloads | |
---|---|---|---|
Supplemental Files
Any supplemental files, not containing data.
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 |
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:
- What is the economic impact of pollination by animals on the economic value of crop production in a given area and a given year?
- 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?
- What is the proportion of agricultural land requiring pollination by animals in the total agricultural land in a given area and a given year?
- 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?
- Which animals are potential pollinators of a given crop or a given plant species in an area?
- Which pollinating insects are potentially threatened due to the application of plant protection products on a crop in an area?
Unresolved issues
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.
Data Providers
Reviewed by
Rubinigg Michael as Data scientist, San Martin Gilles as Data scientistDiscussion (0)
Simple software applications such as spreadsheets (Microsoft Excel, Apache OpenOffice Calc) are sufficient to analyse the data.
No regulatory standard applied.
No technical standard applied.