| Literature DB >> 34716345 |
Rasmus Einarsson1,2, Alberto Sanz-Cobena3, Eduardo Aguilera3, Gilles Billen4, Josette Garnier4, Hans J M van Grinsven5, Luis Lassaletta6.
Abstract
This paper presents EuropeAgriDB v1.0, a dataset of crop production and nitrogen (N) flows in European cropland 1961-2019. The dataset covers 26 present-day countries, detailing the cropland N harvests in 17 crop categories as well as cropland N inputs in synthetic fertilizers, manure, symbiotic fixation, and atmospheric deposition. The study builds on established methods but goes beyond previous research by combining data from FAOSTAT, Eurostat, and a range of national data sources. The result is a detailed, complete, and consistent dataset, intended as a basis for further analyses of past and present agricultural production patterns, as well as construction of scenarios for the future.Entities:
Mesh:
Substances:
Year: 2021 PMID: 34716345 PMCID: PMC8556239 DOI: 10.1038/s41597-021-01061-z
Source DB: PubMed Journal: Sci Data ISSN: 2052-4463 Impact factor: 6.444
Fig. 1Cropland N budgets for a selection of countries in this study. The top left panel shows results for the 22 present-day countries which this study covers 1961–2019.
Fig. 2Crop areas and crop N harvests in a selection of countries in this study. The top left panel shows results for the 22 present-day countries which this study covers 1961–2019.
Fig. 3Average rates of synthetic N fertilizer applied to cropland and permanent grassland. The figure shows all countries where more than 3% of the cumulative N fertilizer use has been applied to permanent grassland. The top left panel shows results for the 22 present-day countries which this study covers 1961–2019.
Fig. 4Trajectories in terms of total cropland N harvest and total N input rate to cropland (synthetic fertilizer, manure, symbiotic fixation, and atmospheric deposition). The top left panel shows results for the 22 present-day countries which this study covers 1961–2019.
Main international databases used.
| Dataset | Version date | Refs. |
|---|---|---|
| FAOSTAT crop production, normalized | 2021-01-13 | [ |
| FAOSTAT land use, normalized | 2021-01-13 | [ |
| FAOSTAT fertilizer nutrients, 1961-present, normalized | 2021-01-13 | [ |
| Eurostat Annual Crop Statistics (ACS) (apro_cpnh1, apro_cpsh1) | 2020-12-14 23:00 | [ |
| Eurostat Annual Crop Statistics (ACS), historical (apro_cpnh1_h) | 2020-02-27 11:00 | [ |
| Eurostat fertilizer consumption (aei_fm_usefert) | 2021-01-04 11:00 | [ |
| Eurostat sales of manufactured fertilizers (aei_fm_manfert) | 2020-09-08 23:00 | [ |
| Eurostat Farm Structure Survey (FSS) 2005–2016 (ef_lus_allcrops) | 2019-09-13 23:00 | [ |
| Eurostat Farm Structure Survey (FSS): farmland 1990–2007 (ef_lu_ovcropaa) | 2019-05-06 23:00 | [ |
| IFA fertilizer consumption | 2021-01-28 | [ |
For the FAOSTAT and IFA sources the version date refers to the download date, and for the Eurostat sources it refers to the publication date in Eurostat’s bulk download facility.
Fig. 5Overview of the main data sources and results of this study. Major input datasets colored blue. Major derived results colored orange.
This list covers all non-standard abbreviations and symbols used in more than one subsection of the paper or in the data record.
| Variable name referring to crop or land areas, e.g., | |
| ACS | Annual Crop Statistics (Eurostat dataset). |
| C | Used as a subscript to denote cropland, e.g., |
| C − TG | Used as a subscript to denote cropland excluding temporary grassland, e.g., |
| CLRTAP | Convention on Long-Range Transboundary Air Pollution |
| EFMA | The European Fertilizer Manufacturers Association. (Today known as Fertilizers Europe.) |
| EU27 | Used here to refer to the former European Union 2007–2013, having 27 member states (before Croatia joined to form EU28). |
| EU28 | The European Union 2013–2020, with 28 member states. |
| EuropeAgriDB | The name of the dataset described in this study. |
| Eurostat | The statistics office of the EU. |
| FAO | Food and Agriculture Organization of the United Nations. |
| FAOSTAT | FAO’s statistics organization. |
| FSS | Farm Structure Survey, Eurostat’s triennial survey of agriculture in the EU. |
| G0000 | Eurostat crop code “Plants harvested green from arable land” |
| G1000 | Eurostat crop code “Temporary grasses and grazings” |
| G2000 | Eurostat crop code “Leguminous plants harvested green” |
| G2100 | Eurostat crop code “Lucerne” (alfalfa) |
| G2900 | Eurostat crop code “Other leguminous plants harvested green n.e.c.” |
| G3000 | Eurostat crop code “Green maize” |
| G9000 | Eurostat crop code “Other plants harvested green from arable land” |
| G9100 | Eurostat crop code “Other cereals harvested green (excluding green maize)” |
| G9900 | Eurostat crop code “Other plants harvested green from arable land n.e.c.” |
| Gg | Gigagram = 109 g = 106 kg = thousand metric tonnes. |
| IFA | The International Fertilizer Association. |
| kha | Thousand (103) hectares. |
| Mha | Million (106) hectares. |
| PG | Used as a subscript to denote permanent grassland, e.g., |
| PGf | Used as a subscript to denote fertilized permanent grassland, e.g., |
| Variable name referring to (annual) fertilizer quantities expressed, e.g., in Gg N/yr. | |
| Variable name referring to fertilizer rates expressed, e.g., in kg N/ha/yr. | |
| R0000 | Eurostat crop code “Root crops” |
| R1000 | Eurostat crop code “Potatoes (including seed potatoes)” |
| R2000 | Eurostat crop code “Sugar beet (excluding seed)” |
| R9000 | Eurostat crop code “Other root crops n.e.c.” |
| TG | Used as a subscript to denote temporary grassland, e.g., |
| TGf | Used as a subscript to denote fertilized temporary grassland, e.g., |
| UNFCCC | United Nations Framework Convention on Climate Change |
| Variable name referring to crop N yields expressed, e.g., in kg N/ha/yr. |
In addition, all abbreviations and symbols are defined on their first mention throughout the text.
Fig. 6Illustration of main data sources and transformation steps used to estimate areas and N harvests in 17 crop categories. Major input datasets colored blue. Major derived results colored orange. Intermediate transformation steps in gray.
The crop categories resulting from the crop data processing.
| Data sources | Crop category | Number of source crop codes |
|---|---|---|
| FAOSTAT | Wheat | 1 |
| ” | Barley | 1 |
| ” | Grain maize | 1 |
| ” | Other cereals | 9 |
| ” | Oilseeds | 15 |
| ” | Potatoes | 1 |
| ” | Sugar beet | 1 |
| ” | Pulses | 9 |
| ” | Vegetables and other | 41 |
| ” | Olives | 1 |
| ” | Grapes | 1 |
| ” | Other permanent crops | 40 |
| Eurostat and others | Green maize | 1 |
| ” | Temporary grassland | 1 |
| ” | Forage legumes | 2 |
| ” | Fodder roots | 1 |
| ” | Other forage crops | 1 |
Some categories are based on data from a single crop code in the FAOSTAT or Eurostat crop production databases: these are major crops that together typically cover 50–80% of the cropland in each country. The full categorization is given in the data record[12].
Excerpt from Eurostat’s hierarchy of crop codes[23].
| Crop code | Label |
|---|---|
| G0000 | Plants harvested green from arable land |
| | |
| G2000 | Leguminous plants harvested green |
| | |
| | |
| | |
| | |
| G9100 | Other cereals harvested green (excluding green maize) |
| G9900 | Other plants harvested green from arable land n.e.c. |
| R0000 | Root crops |
| R1000 | Potatoes (including seed potatoes) |
| R2000 | Sugar beet (excluding seed) |
| |
The crops included in this study and referred to as “fodder crops” are marked in bold face.
N contents assumed for the fodder crops.
| Crop code | N content (% N of DM) | Comment | References |
|---|---|---|---|
| G1000 | 2.3 | 75% grass (2.0% N), 25% clover (3.3% N) | [ |
| G2100 | 3.0 | [ | |
| G2900 | 3.2 | 90% clover (3.3% N), 10% grass (2.0% N) | [ |
| G3000 | 1.2 | [ | |
| G9000 | 2.0 | 75% cereal forage (1.6% N), 25% legumes (3.0% N) | [ |
| R9000 | 1.3 | Fodder beet | [ |
Fig. 7Illustration of main data sources and transformation steps used to estimate the application of synthetic fertilizer on cropland and permanent grassland. Major input datasets colored blue. Major derived results colored orange. Intermediate transformation steps in gray.
Aggregation of UNFCCC manure management systems.
| Simplified classes | UNFCCC classes |
|---|---|
| Grazing | “Pasture range and paddock” |
| Solid | “Composting”, “Daily spread”, “Solid storage and dry lot” |
| Liquid | “Anaerobic lagoon”, “Digesters”, “Liquid system” |
| Other | “Other” |
Also available in machine-readable form in the data record[12].
Aggregation of UNFCCC livestock classes.
| Simplified classes | UNFCCC classes |
|---|---|
| Ruminants and equines | “Cattle”, “Sheep”, “Buffalo”, “Goats”, “Horses”, “Mules and Asses” |
| Pigs | “Swine” |
| Poultry and rabbits | “Poultry”, “Rabbit” |
Also available in machine-readable form in the data record[12].
| Measurement(s) | agricultural process |
| Technology Type(s) | Survey |
| Factor Type(s) | year • geographic location |
| Sample Characteristic - Environment | agriculture |
| Sample Characteristic - Location | Europe |