R project to assess the environmental impacts of the main Spanish crops at a regional level
The collated data correspond to the parameters to estimate the resources consumption and the emissions to the environment from the main farming activities (resources consumption and emissions from infrastructure building and management, fertiliser and pesticide production, on-field fertiliser and pesticide emissions, fuel consumption from machinery use, and irrigation), together with the environmental impacts of the unit processes (e.g. electricity mix, production of agricultural inputs) required to assess the environmental impacts from a panel of reference holdings at the main NUTS 2 in Spain. These data were compiled in a set of excel sheets and subsequently operated (tidying, transforming, visualisation and modelling operations) by developing a set of scripts using R programming language and the RStudio interface.
Steps to reproduce
From Spanish ECREA farm accountancy reports, a reference dataset was created (Dbi1_ECREA) where the reference holdings studied were defined. Additional data from official statistics and scientific literature was gathered to develop the life cycle inventory to assess the environmental impacts of the reference holdings. Most of the collated data was compiled in excel files; only some parameters to estimate the energy consumption for irrigation were included directly in the R code. In the R code, functions to filter, select, join, summarise, simulate, etc., were applied to obtain, from the input data, the inventory data, and environmental impact scores of the reference holdings.
Universitat Politècnica de València
research contract through Subprogram 1 (PAID-01-18)
Departamento Administrativo de Ciencia, Tecnología e Innovación (COLCIENCIAS)