C2D2 V200 - Revision history

Hendrik: /* Pre-processing */

2024-12-23T10:09:04Z

Pre-processing

← Older revision		Revision as of 10:09, 23 December 2024
Line 67:		Line 67:


	The location is based on the most detailed geographic definition which is the attribute Grid10km. This is the EEA 10km reference grid (https://www.eea.europa.eu/data-and-maps/data/eea-reference-grids-2). The coordinates are given in the form of a string as "10kmE{x}N{y}" where {y} represents ~~100000~~ m north from a reference point and {x} ~~100000~~ m east of a reference point according to the LAEA coordinate systems. {x} and {y} were multiplied with ~~100000~~ to convert their units to m and convert them to EPSG:3035. Subsequently, the obtained EPSG:3035 coordinates X and Y were converted to the EPSG:4326 coordinates longitude, latitude using the to_crs() function in the Python package Geopandas.		The location is based on the most detailed geographic definition which is the attribute Grid10km. This is the EEA 10km reference grid (https://www.eea.europa.eu/data-and-maps/data/eea-reference-grids-2). The coordinates are given in the form of a string as "10kmE{x}N{y}" where {y} represents 10000 m north from a reference point and {x} 10000 m east of a reference point according to the LAEA coordinate systems. {x} and {y} were multiplied with 10000 to convert their units to m and convert them to EPSG:3035. Subsequently, the obtained EPSG:3035 coordinates X and Y were converted to the EPSG:4326 coordinates longitude, latitude using the to_crs() function in the Python package Geopandas.

	As the location is based on a 10 km grid we defined the geometry accuracy as 10000 m.		As the location is based on a 10 km grid we defined the geometry accuracy as 10000 m.

Hendrik: /* Pre-processing */

2024-12-23T09:23:11Z

Pre-processing

← Older revision		Revision as of 09:23, 23 December 2024
Line 67:		Line 67:


	The location is based on the most detailed geographic definition which is the attribute Grid10km. This is the EEA 10km reference grid (https://www.eea.europa.eu/data-and-maps/data/eea-reference-grids-2). The coordinates are given in the form of a string as "~~10kmN~~{y}E{x}" where {y} represents 100000 m north from a reference point and {x} 100000 m east of a reference point according to the LAEA coordinate systems. {x} and {y} were multiplied with 100000 to convert their units to m and convert them to EPSG:3035. Subsequently, the obtained EPSG:3035 coordinates X and Y were converted to the EPSG:4326 coordinates longitude, latitude using the to_crs() function in the Python package Geopandas.		The location is based on the most detailed geographic definition which is the attribute Grid10km. This is the EEA 10km reference grid (https://www.eea.europa.eu/data-and-maps/data/eea-reference-grids-2). The coordinates are given in the form of a string as "10kmE{x}N{y}" where {y} represents 100000 m north from a reference point and {x} 100000 m east of a reference point according to the LAEA coordinate systems. {x} and {y} were multiplied with 100000 to convert their units to m and convert them to EPSG:3035. Subsequently, the obtained EPSG:3035 coordinates X and Y were converted to the EPSG:4326 coordinates longitude, latitude using the to_crs() function in the Python package Geopandas.

	As the location is based on a 10 km grid we defined the geometry accuracy as 10000 m.		As the location is based on a 10 km grid we defined the geometry accuracy as 10000 m.

Hendrik: /* Pre-processing */

2024-10-19T10:34:04Z

Pre-processing

← Older revision		Revision as of 10:34, 19 October 2024
Line 73:		Line 73:

	The unique name (object id) is based:		The unique name (object id) is based:
	* ~~trial~~ year (attribute TrialYearRaw)		* Trial year (attribute TrialYearRaw)
	* ~~crop~~ (attribute CropNameHarmonisedFinal)		* Crop (attribute CropNameHarmonisedFinal)
	* ~~location~~ (attribute RecordGroupID)		* Location (attribute RecordGroupID)

Hendrik: /* Pre-processing */

2024-10-19T10:33:01Z

Pre-processing

← Older revision		Revision as of 10:33, 19 October 2024
Line 61:		Line 61:

	Data of the following crops were combined and defined under one crop:		Data of the following crops were combined and defined under one crop:
	* Common rice, Dry-seeded paddy rice, Seeded upland rice, Wet-seeded paddy ric and Rice		* Common rice, Dry-seeded paddy rice, Seeded upland rice, Wet-seeded paddy ric and Rice (Rice)
	* Field Pea and Pea		* Field Pea and Pea (Pea)
	* Flint Corn, Flour Corn, Sweet Corn, Waxy Maize and Maize		* Flint Corn, Flour Corn, Sweet Corn, Waxy Maize and Maize (Maize)
	* Spring Turnip Rape and Spring Rape		* Spring Turnip Rape and Spring Rape (Spring Rape)

Hendrik at 17:11, 18 October 2024

2024-10-18T17:11:46Z

← Older revision		Revision as of 17:11, 18 October 2024
Line 87:		Line 87:
	Attribute: GSFinal<br>		Attribute: GSFinal<br>
	Remark: GSFinal is an observed phenology stage, expressed according the BBCH scale, and is valid for the date given by attribute GSDateFinal		Remark: GSFinal is an observed phenology stage, expressed according the BBCH scale, and is valid for the date given by attribute GSDateFinal


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

Hendrik: /* CROP_DEV_BBCH */

2024-10-18T17:11:29Z

CROP_DEV_BBCH

← Older revision		Revision as of 17:11, 18 October 2024
Line 86:		Line 86:
	=== CROP_DEV_BBCH ===		=== CROP_DEV_BBCH ===
	Attribute: GSFinal<br>		Attribute: GSFinal<br>
	Remark: GSFinal is an observed phenology stage, expressed according the BBCH scale, and valid the date given by attribute GSDateFinal		Remark: GSFinal is an observed phenology stage, expressed according the BBCH scale, and is valid for the date given by attribute GSDateFinal

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

Hendrik at 17:09, 18 October 2024

2024-10-18T17:09:57Z

← Older revision		Revision as of 17:09, 18 October 2024
Line 67:		Line 67:


	The location is based on the most detailed geographic definition which is the attribute Grid10km. This is the EEA 10km reference grid (https://www.eea.europa.eu/data-and-maps/data/eea-reference-grids-2). The coordinates are given in the form of a string as "10kmN{y}E{x}" where {y} represents ~~105~~ m north from a reference point and {x} ~~105~~ m east of a reference point according to the LAEA coordinate systems. {x} and {y} were multiplied with ~~105~~ to convert their units to m and convert them to EPSG:3035. Subsequently, the obtained EPSG:3035 coordinates X and Y were converted to the EPSG:4326 coordinates longitude, latitude using the to_crs() function in the Python package Geopandas.		The location is based on the most detailed geographic definition which is the attribute Grid10km. This is the EEA 10km reference grid (https://www.eea.europa.eu/data-and-maps/data/eea-reference-grids-2). The coordinates are given in the form of a string as "10kmN{y}E{x}" where {y} represents 100000 m north from a reference point and {x} 100000 m east of a reference point according to the LAEA coordinate systems. {x} and {y} were multiplied with 100000 to convert their units to m and convert them to EPSG:3035. Subsequently, the obtained EPSG:3035 coordinates X and Y were converted to the EPSG:4326 coordinates longitude, latitude using the to_crs() function in the Python package Geopandas.

	As the location is based on a 10 km grid we defined the geometry accuracy as 10000 m.		As the location is based on a 10 km grid we defined the geometry accuracy as 10000 m.

Hendrik at 11:51, 18 October 2024

2024-10-18T11:51:04Z

← Older revision		Revision as of 11:51, 18 October 2024
Line 21:		Line 21:
	** No crop defined (attribute CropNameHarmonisedFinal)		** No crop defined (attribute CropNameHarmonisedFinal)
	** No year defined (attribute TrialYearRaw)		** No year defined (attribute TrialYearRaw)
	* Duplicates were removed thus data records having the same experiment (attribute RecordGroupID, the same location (attribute Grid10km), the same trial year (attribute TrialYearRaw), the same crop (attribute CropNameHarmonisedFinal), the same phenology stage (attribute GSFinal), and the same observation date (attribute GSDateFinal). There is one exception. In case an experiment had ~~more than one~~ observation ~~date~~ for a combination of experiment, location, trial year, crop and phenology stage the data record was not removed if ~~the~~ variation of ~~these dates~~ was limited to 10 days of less.		* Duplicates were removed thus data records having the same experiment (attribute RecordGroupID, the same location (attribute Grid10km), the same trial year (attribute TrialYearRaw), the same crop (attribute CropNameHarmonisedFinal), the same phenology stage (attribute GSFinal), and the same observation date (attribute GSDateFinal). There is one exception. In case an experiment had varying observation dates for a combination of experiment, location, trial year, crop and phenology stage the data record was not removed if this variation of was limited to 10 days of less.
			* Cases where a combination of experiment, location, trial year, crop and observation date had varying phenology stages were removed as we expect that on a specific day only one stage is observed.
	* We did not keep all the crops, we only included the following crops (attribute CropNameHarmonisedFinal):		* We did not keep all the crops, we only included the following crops (attribute CropNameHarmonisedFinal):
	** Chickpea		** Chickpea

Hendrik at 10:13, 18 October 2024

2024-10-18T10:13:22Z

@@ Line 2: / Line 2: @@
 == Provider's website ==
-[https://zenodo.org/records/8393135]
+[https://zenodo.org/records/8393135] Downloaded file C2D2_database_v200.sqlite. Note it was necessary to vacuum the database, before it could be used for further analysis.
-[https://doi.org/10.1002/ieam.4870]
+[https://doi.org/10.1002/ieam.4870] Hughes et al., 2024
 == Documentation ==
@@ Line 12: / Line 11: @@
 == Pre-processing  ==
-Original data filtered:
+Data of table Processed_Data, containing fully processed data, was selected and further processed.
-The comment is based:
+Original data was filtered:
-* xxx
+* Incomplete data was excluded, thus records that had one or more attribute values missing:

Hendrik at 08:45, 18 October 2024

2024-10-18T08:45:14Z

← Older revision		Revision as of 08:45, 18 October 2024
Line 1:		Line 1:
	xxx		The CropLife Europe Crop Development Database (C2D2) includes harmonized observations of crop development stages for 102 distinct crop species throughout Europe. (Hughes et al., 2024). The C2D2 data set consists of data that were collected by seven member companies of CropLife Europe (namely Corteva Agriscience, ADAMA Agricultural Solutions, BASF SE Agricultural Solutions, Bayer AG Crop Science Division, FMC Agricultural Solutions, Sumitomo Chemical and Syngenta Ltd) and subsequently harmonized in a single database.

			== Provider's website ==
			[https://zenodo.org/records/8393135]
			Downloaded file C2D2_database_v200.sqlite

			[https://doi.org/10.1002/ieam.4870]

			== Documentation ==
			Hughes, G.O., Eatherall, A., Bird, M., Blake, J., Branford, P.R., Gebler, S., Lozano, A., Massey, P.A., Reinken, G., Terry, A.S. and Whitworth, E.H., 2024. CropLife Europe Crop Development Database: An open‐source, pan‐European, harmonized crop development database for use in regulatory pesticide exposure modeling and risk assessment. Integrated Environmental Assessment and Management, 20(4), pp.1060-1074.


			== Pre-processing ==
			Original data filtered:
			* xxx

			The unique name (object id) is based:
			* xxx

			The comment is based:
			* xxx



			The geometry accuracy is based xxxx.


			=== CROP_CODE ===
			Attribute: CropNameHarmonisedFinal<br>
			Remark: -


			=== CROP_DEV_BBCH ===
			Attribute: GSFinal<br>
			Remark: GSFinal is an observed phenology stage, expressed according the BBCH scale, and valid the date given by attribute GSDateFinal

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