ERA Africa: Difference between revisions

From AgroStac
Jump to navigationJump to search
No edit summary
Line 8: Line 8:


== Pre-processing ==
== Pre-processing ==
Original data of file '01a. ERA_Compiled.csv' was filtered:
Original data of file '01a. ERA_Compiled.csv' was repaired, merging splitted lines, and afterwards processed and filtered:
* Only include records that have information on the journal, DOI, Product.Simple (crop label)
* Only include observations of arable annual crops
* Only include observations of arable annual crops
* Only extract the sowing and harvest date
* Only extract the sowing and harvest date
* Harvest must be at least 30 days later than sowing <to be checked>
* At least one of the fields of Plant.Start, Plant.End, Harvest.Start or Harvest.End must have a value
* The record was not copied if there is no valid planting date and no valid harvest date
* The record was not copied if the planting date and harvest date differ by less than 90 days


The unique name is constructed from the initial string 'ERA_Africa_', concatenated with the attributes:
The unique name is constructed from the initial string 'ERA_Africa_', concatenated with the attributes:
Line 20: Line 23:


The comment is based on the following attributes:
The comment is based on the following attributes:
* Site.Key
* Site.Key (latitude and longitude)
* DOI
* DOI
* Product.Simple
* Product.Simple (crop label)


The geometry accuracy is copied from the attribute Buffer.
The geometry accuracy is copied from the attribute Buffer.
Elevation is only loaded if the elevation field in the .csv file consists of one number.


=== CROP_CODE ===
=== CROP_CODE ===
Line 32: Line 37:


=== CROP_DEV_BBCH ===
=== CROP_DEV_BBCH ===
Attribute: Plant.Start and Harvest.Start <to be checked>
Attribute: Plant.Start, Pant.End, Harvest.Start and Harvest.End


Remark: xxx
Remark:  
* If there is a Plant.Start and a Plant.End, the planting date was considered the average rounded to the nearest date, unless they differ by more than 30 days
* If there is a Harvest.Start and a Harvest.End, the harvest date was considered the average rounded to the nearest date, unless they differ by more than 30 days


=== Management ===
=== Management ===
There was no further information on the crop management.
There was no further information on the crop management.

Revision as of 13:06, 10 October 2025

The Evidence for Resilient Agriculture (ERA v1.0.1) dataset contains observations from agricultural studies conducted in Africa from 1934 to 2018. ERA examines the efficacy of agricultural practices on environmental, social, and agricultural-economic outcome indicators. For AGROSTAC the phenology (start and end) was extracted.

Provider's website

[1] Evidence for Resilient Agriculture Dataset v1.0.1. The file '01a. ERA_Compiled.csv' was selected.

Documentation

[2] Evidence for Resilient Agriculture Dataset v1.0.1.

Pre-processing

Original data of file '01a. ERA_Compiled.csv' was repaired, merging splitted lines, and afterwards processed and filtered:

  • Only include records that have information on the journal, DOI, Product.Simple (crop label)
  • Only include observations of arable annual crops
  • Only extract the sowing and harvest date
  • At least one of the fields of Plant.Start, Plant.End, Harvest.Start or Harvest.End must have a value
  • The record was not copied if there is no valid planting date and no valid harvest date
  • The record was not copied if the planting date and harvest date differ by less than 90 days

The unique name is constructed from the initial string 'ERA_Africa_', concatenated with the attributes:

  • Site.Key
  • DOI
  • Product.Simple

and finally a sequence number in case if multiple treatments.

The comment is based on the following attributes:

  • Site.Key (latitude and longitude)
  • DOI
  • Product.Simple (crop label)

The geometry accuracy is copied from the attribute Buffer.

Elevation is only loaded if the elevation field in the .csv file consists of one number.

CROP_CODE

Attribute: Product.Simple

Remark: selected annual arable crops

CROP_DEV_BBCH

Attribute: Plant.Start, Pant.End, Harvest.Start and Harvest.End

Remark:

  • If there is a Plant.Start and a Plant.End, the planting date was considered the average rounded to the nearest date, unless they differ by more than 30 days
  • If there is a Harvest.Start and a Harvest.End, the harvest date was considered the average rounded to the nearest date, unless they differ by more than 30 days

Management

There was no further information on the crop management.