An Environmental Extension of the Farm Accountancy Data Network using Geolocations

This report documents the Environmental Master Tables (ENVMAT) framework, a comprehensive data integration system linking heterogeneous environmental datasets with microeconomic data from the Farm Accountancy Data Network (FADN) based on geolocations. The framework addresses fundamental data interoperability challenges: temporal misalignment between high-frequency environmental observations and annual economic reporting, spatial mismatch between gridded environmental data and point-based observations, and heterogeneity across environmental data sources. We integrate high-resolution climate reanalysis data (AgERA5), soil moisture data (GLEAM), and soil property maps (ESDAC) with approximately 900,000 FADN observations from 2011 to 2021. A three-phase modular workflow performs dataset-specific processing, multi-scale spatial integration via zonal summary statistics, and produces temporally aligned master tables with optional imputation of missing values. The resulting database provides approximately 10,000 environmental variables capturing temporal dynamics and spatial heterogeneity across point, 5km radius buffer, and NUTS3 integrations. The framework establishes a reproducible template for environmental-economic data integration at scale, supporting a broad range of applications in policy analysis and environmental economic research.