home    about    browse    search    latest    help 
Login | Create Account

Dairy database for prediction of main environmental challenges to resilience and efficiency in cattle production systems at regional resolution (Version V1.0)

Quiédeville, Sylvain; Moakes, Simon; Leiber, Florian and Pfeifer, Catherine (2020) Dairy database for prediction of main environmental challenges to resilience and efficiency in cattle production systems at regional resolution (Version V1.0). .

[thumbnail of Dairy_database_2011-2013_28.05.20_Upload.xlsx] Microsoft Excel - English
2MB
[thumbnail of GenTORE - Deliverable number: 1:2] Microsoft Word - English (GenTORE - Deliverable number: 1:2)
1MB

Document available online at: https://zenodo.org/record/3860704


Summary

The dairy database comprises average values for a wide range of variables (110 or 119), available in 4 worksheets: BasicFarmType (18 rows), DetailedFarmType (10 rows), ClimateClass+BasicFarmType (100 rows), NUTS+DetailedFarmType (1452 rows). Data are omitted when the sample size (n) is below 15, as per the confidentiality agreement under FADN data use rules.
A combined farm characterisation database was constructed using two major data sources, the Farm Accountancy Data Network (FADN), and the Gridded Agro-Meteorological Data in Europe (AGRI4CAST). The database initially constructed was further enhanced through the addition of forage and crop yield data from the Food and Agriculture Organization of the United Nations (FAO) and the International Institute for Applied Systems Analysis (IIASA) developed Agro-Ecological Zones (AEZ) methodology database (FAO, 2012). The data was processed and is presented in D1.2 as two databases (dairy and beef), as averages for a wide range of variables at basic or detailed farm types, and at NUTS2 regional scale.
Detailed FADN data (anonymised individual farm data) was requested for all ruminant and mixed farm types, over 10 years and the most recent data available at request (2004-2013). Following receipt of the data (~250k farms) this has been compiled into two consistent datasets, one for dairy (141,961) farms and one for beef farms (54,417). Each dataset comprises some values directly from the FADN data, but also a large number of calculated variables, to identify dairy or beef enterprise performance at per animal, per output product unit or per hectare. These values were calculated according to the respective dairy and beef enterprise allocation methodologies described by FADN. Further economic and structural variables have been calculated as necessary, as described in GenTORE D1.1 (Quiédeville et al., 2019).
For each farm within the dataset, the structural, production and economic data from the FADN data is supplemented with the addition of meteorological data. The daily meteorological data was downloaded from the AGRI4STAT database web portal at a NUTS2 scale. For each NUTS2 region data was available for a number of weather stations. This large dataset was processed through scripts in STATA software to generate annual values for a wide range of climatic variables, including Temperature Humidity Index (THI), and indicators of drought and seasonality of weather. Furthermore, the altitude values per weather station allowed for a sub-grouping of weather station data by altitude zone (aligned with values available in the FADN dataset).
Using a Latent Class Analysis process, the meteorological data was analysed to identify consistent environmental regions in Europe. Selected climatic variables, together with altitude zone, were utilised to statistically identify differing zones, and to classify each NUTS2 region to a zone, resulting in 6 lowland zones and 3 upland zones (above 600m) The LCA process enhanced an earlier method of manually overlaying the Metzger et al. (20054) pedo-climatic zone allocation, but closely correlates. Therefore for each farm in the dairy and beef datasets, meteorological and environmental zone data was allocated on a NUTS2 by altitude zone basis and this dataset has been subsequently assessed and submitted as papers; Quiédeville et al., (submitted May 2020) and Grovermann et al. (submitted May 2020).
The GAEZ forage and crop yield data was downloaded from the GAEZ data portal as baseline and two future climate prediction periods: Baseline (1961-2000), 2020s (2011-2040), and 2050s (2041-2070), for the Hadley CM3 model and IPCC scenario A (the most extreme scenario). See: http://www.fao.org/nr/gaez/about-data-portal/agro-climatic-resources/en/#). A zonal statistics was applied to the GAEZ layers to aggregate the data to NUT2 region and altitude zone (0-300m, 300-600m, 600m+) with raster package in R. The result is an average yield[1] for varying forages and crops for each altitude zone in each nuts2, for both the baseline and the future climate scenario. This data allows further analysis of the future impacts on cattle farming at both a regional scale, but also by farm type or system, which may be affected differently (Moakes et al. in preparation).
All variable processing from FADN data is shown in the Annex, as performed in Stata software.


EPrint Type:Data set
Keywords:dairy, cattle, facin, climate, climate class, farm type, region, NUTS2, database, efficiency, resilience, EU, Abacus, FiBL5008101
Agrovoc keywords:
Language
Value
URI
English
data bases -> databases
http://aims.fao.org/aos/agrovoc/c_24833
English
cattle
http://aims.fao.org/aos/agrovoc/c_1391
English
resilience
http://aims.fao.org/aos/agrovoc/c_1374480530924
Subjects: Animal husbandry > Production systems > Dairy cattle
Knowledge management > Research methodology and philosophy > Specific methods > Surveys and statistics
Animal husbandry > Production systems > Beef cattle
Research affiliation: Switzerland > FiBL - Research Institute of Organic Agriculture Switzerland > Animal > Cattle
Switzerland > FiBL - Research Institute of Organic Agriculture Switzerland > Sustainability > Climate
Horizon Europe or H2020 Grant Agreement Number:727213
Deposited By: Forschungsinstitut für biologischen Landbau, FiBL
ID Code:39002
Deposited On:25 Jan 2021 14:02
Last Modified:25 Jan 2021 14:05
Document Language:English
Status:Published

Repository Staff Only: item control page

Downloads

Downloads per month over past year

View more statistics