Edible Plants and Regional Climate Dataset

This dataset combines botanical, nutritional, and climate data for edible plants across European regions.

---

Dataset Structure

The database contains three tables:

Table	Purpose
plants	Botanical, cultivation, and nutritional info about edible plants
regions	NUTS-2 European regions with geographic coordinates
climate_data	Monthly average temperature per region

---

plants

Contains plant-specific information.

Key fields:

• full_taxonomic_name – scientific plant name
• common_name – common name
• cultivation_group_(rotational_information) – crop rotation classification
• sunlight_requirements, temperature_class, nutrient_requirements, preferred_ph, water_requirements, plant_requirements, descriptive_growing_season
• nutritional_information, energy_value_per_100g_raw_kcal
• general_description, sensitivities, pests_and_pathogens, disease_management, soil
• optimum_germination_temerature, days_to_germination_at_optimum_temperature, plant_growing_ideal_temperature, length_of_gorwing_to_harvest
• image_product, image_plant

The images can be found at https://plant-calendar.app.max-richter.dev/vegetables/{plantName}.webp

Example:

---

regions

Fields:

• id – NUTS-2 region code
• name – region name
• lat, lon – centroid coordinates

---

climate_data

Fields:

• region_id – NUTS-2 region identifier
• month – month (1–12)
• avg_temp – average temperature in °C

---

Data Sources

• Plant Database – University of Dundee Edible Plant Database: https://discovery.dundee.ac.uk/en/datasets/edible-plant-database/
• Climate Data – Open-Meteo: https://open-meteo.com/
• Regional Data – Eurostat Nuts2json: https://github.com/eurostat/Nuts2json

---

Notes

• Climate values represent average monthly temperatures.
• Region definitions follow the Eurostat NUTS-2 classification.
• Plant cultivation parameters are based on publicly available horticultural data.