r2-landbrugsareal-data

name	r2-landbrugsareal-data
description	Activates when querying agricultural land and field data from R2. Use this skill for: field boundaries, crop data, land use, organic farming, production estimates, cadastral data, agricultural blocks, building data. Keywords: landbrugsareal, field, mark, marker, crop, afgrøde, organic, økologisk, production, areal, cadastral, matrikel

R2 Landbrugsareal (Agricultural Land) Data Catalog

Field boundaries, crop data, land use, and agricultural production data.

Frontend Metrics Supported

Metric Key	Danish Name	Description
land_use	Arealanvendelse	Land use categories
organic_farming	Økologisk areal	Organic farming area
production	Afgrødeproduktion	Crop production estimates
crop_diversity	Afgrødediversitet	Diversity of crops grown

Available Datasets

Silver Layer

FVM Marker - Field Boundaries (617K rows/year)

Path: r2://landbruget-data/silver/fvm_marker_{year}/*/data.parquet Years Available: 2008-2025

Column	Type	Description	Example
field_id	string	Unique field identifier	610341-27-1-0
area_ha	float	Field area in hectares	12.45
cvr_number	string	Company CVR (8 digits)	31373077
crop_code	int	Crop type code	1
crop_name	string	Crop type name	Vårbyg
block_id	string	Agricultural block ID	610341-27
geometry	binary	Field polygon (WKB, EPSG:4326)	-
year	int	Data year	2024
field_uuid	string	UUID for field	-
municipality	string	Municipality code	0101
is_organic	bool	Organic certification	true
organic_conversion_date	date	Date of organic conversion	2020-01-15

Schema (introspected):

field_id: string
area_ha: double
cvr_number: string
crop_code: int64
crop_name: string
block_id: string
geometry: binary (WKB)
year: int64
field_uuid: string
municipality: string
is_organic: bool
organic_conversion_date: date32
[20 columns total]

Agricultural Blocks

Path: r2://landbruget-data/silver/agricultural_blocks_{year}/*/data.parquet

Column	Type	Description
block_id	string	Block identifier
geometry	binary	Block polygon (WKB)
total_area_ha	float	Total block area

Cadastral (2.16M rows)

Path: r2://landbruget-data/silver/cadastral/*/data.parquet

Column	Type	Description	Example
bfe_number	int64	Cadastral parcel ID	1234567
business_event	string	Last registration event	-
registration_from	timestamp	Registration date	-
is_worker_housing	bool	Worker housing flag	false
is_common_lot	bool	Common lot flag	false
agricultural_notation	string	Agricultural notation	-
geometry	binary	Parcel polygon (WKB)	-

BBR Buildings (579K rows)

Path: r2://landbruget-data/silver/bbr_buildings/*/joined_buildings.parquet

Column	Type	Description
building_uuid	string	Unique building ID
geo_building_polygon	binary	Building footprint (WKB)
geo_building_centroid	binary	Building center point
building_type	string	Building type code
building_floor_area_sqm	float	Floor area in m²
building_usage_category	string	Usage category
current_use	string	Current use description
address	string	Building address

DAGI Kommuner (99 rows)

Path: r2://landbruget-data/silver/dagi_kommuner/*/data.parquet

Column	Type	Description
code	string	Municipality code
name	string	Municipality name
region_code	string	Region code
geometry	binary	Municipality polygon (WKB)
area_m2	float	Area in m²
centroid_x	float	Centroid longitude
centroid_y	float	Centroid latitude

Gold Layer

Field Production (617K rows/year)

Path: r2://landbruget-data/gold/field_production_{year}/*/data.parquet

Column	Type	Description	Example
field_id	string	Field identifier	610341-27-1-0
block_id	string	Block identifier	610341-27
cvr_number	string	Company CVR	31373077
year	int	Production year	2024
area_ha	float	Field area	12.45
crop_type	string	Crop type name	Vårbyg
organic_farming	bool	Organic flag	true
landsdel_code	string	Region code	-
landsdel_name	string	Region name	Nordjylland
dst_regions	string	DST region classification	-
kommune_name	string	Municipality name	København
yield_estimate_hkg_ha	float	Yield estimate hkg/ha	52.3
production_estimate_hkg	float	Total production hkg	651.14
field_uuid	string	UUID	-
primary_field_id	string	Primary field reference	-

Schema (introspected):

field_id: string
block_id: string
cvr_number: string
year: int64
area_ha: double
crop_type: string
organic_farming: bool
landsdel_code: string
landsdel_name: string
dst_regions: string
kommune_name: string
yield_estimate_hkg_ha: double
production_estimate_hkg: double
field_uuid: string
primary_field_id: string
[18 columns total]

Common Queries

Get All Fields for a CVR

import duckdb
from common.storage.filesystem import setup_duckdb_cloud_auth

conn = duckdb.connect()
setup_duckdb_cloud_auth(conn)

# Read FVM marker data for 2024
df = conn.execute("""
    SELECT * FROM read_parquet('r2://landbruget-data/silver/fvm_marker_2024/2025-01-10/data.parquet')
""").df()

# Filter by CVR
company_fields = df[df['cvr_number'] == '31373077']
print(f"Total fields: {len(company_fields)}")
print(f"Total area: {company_fields['area_ha'].sum():.2f} ha")

Calculate Organic Farming Percentage by Municipality

# Group by municipality and organic status
organic_stats = df.groupby(['municipality', 'is_organic']).agg({
    'area_ha': 'sum'
}).unstack(fill_value=0)

organic_stats.columns = ['conventional', 'organic']
organic_stats['organic_pct'] = (
    organic_stats['organic'] /
    (organic_stats['conventional'] + organic_stats['organic']) * 100
)
organic_stats = organic_stats.sort_values('organic_pct', ascending=False)

Get Production Estimates for a Crop

# Read gold production data
production = conn.execute("""
    SELECT * FROM read_parquet('r2://landbruget-data/gold/field_production_2024/2025-01-10/data.parquet')
""").df()

# Filter for wheat
wheat = production[production['crop_type'].str.contains('hvede', case=False)]
print(f"Total wheat area: {wheat['area_ha'].sum():.2f} ha")
print(f"Average yield: {wheat['yield_estimate_hkg_ha'].mean():.2f} hkg/ha")
print(f"Total production: {wheat['production_estimate_hkg'].sum():.2f} hkg")

Crop Diversity Analysis

# Count unique crops per CVR
crop_diversity = df.groupby('cvr_number').agg({
    'crop_name': 'nunique',
    'area_ha': 'sum'
}).reset_index()
crop_diversity.columns = ['cvr_number', 'crop_count', 'total_area']
crop_diversity = crop_diversity.sort_values('crop_count', ascending=False)

Read Geometry with DuckDB Spatial

# Read with geometry via DuckDB
gdf = conn.execute("""
    SELECT * FROM read_parquet('r2://landbruget-data/silver/fvm_marker_2024/2025-01-10/data.parquet')
    WHERE cvr_number = '31373077'
""").df()

Join Keys

This Dataset	Join Column	Target Dataset	Target Column
fvm_marker	cvr_number	subsidies	cvr_number
fvm_marker	field_id	field_production	field_id
fvm_marker	block_id	agricultural_blocks	block_id
fvm_marker	field_uuid	pesticide_disaggregation	field_uuid
fvm_marker	municipality	dagi_kommuner	code
field_production	field_id	nles5_nitrogen	field_id
cadastral	bfe_number	property_owners	bestemtFastEjendomBFENr

Data Quality Notes

FVM Marker

• Update frequency: Annual (new year data released ~Q2)
• Coverage: All registered agricultural fields in Denmark
• Years available: 2008-2025 (varies by data source)
• Geometry: WKB format, EPSG:4326

Field Production

• Update frequency: Annual after harvest statistics
• Coverage: Production estimates for all registered fields
• Caveat: Yield estimates are modeled, not measured

Cadastral

• Update frequency: Weekly
• Coverage: All cadastral parcels in Denmark
• Note: Use for property boundaries, not field boundaries

Related Skills

• okonomi/ - Subsidies linked to fields via CVR and markbloknummer
• miljo/ - Environmental data at field level (pesticides, nitrogen)
• husdyr/ - Livestock density per land area

R2 Paths Reference

# List available FVM marker years
rclone lsd r2:landbruget-data/silver/ | grep fvm_marker

# List field production years
rclone lsd r2:landbruget-data/gold/ | grep field_production

# List cadastral snapshots
rclone lsd r2:landbruget-data/silver/cadastral/

# List DAGI municipality data
rclone lsd r2:landbruget-data/silver/dagi_kommuner/

Yearly Data Pattern

For datasets with yearly data, use this pattern:

# Query specific year
year = 2024
path = f'silver/fvm_marker_{year}/*/data.parquet'

# Query all years (use with caution - large data)
path = 'silver/fvm_marker_*/*/data.parquet'