Occurrence patterns data formats
Agricultural use percentages for plant protection products (PPPs) may be of use for concentration modelling, as they provide information about what substance mixtures are expected to be present simultaneously on food samples. Especially for non-detect concentration measurements, this information may aid to determine whether the non-detect measurement originated from a true zero or may be a positive measurement below the limit of detection. Agricultural use percentages are specified using the agricultural uses and agricultural use substances table. This data format expects agricultural use percentages to be specified for mixtures of substances. Each mixture has an id (idAgriculturalUse) and a list of substances that are part of this mixture (agricultural use substances). These agricultural uses are assumed to be exclusive (i.e., only one mixture or PPP is used per sample). Hence, the sum of the agricultural uses for one food should not exceed 100%.
Download empty dataset template:
Agricultural uses
The AgriculturalUses contains the definitions of the agricultural use mixtures, or PPPs and the specification of the percentage of the products treated with this mixture. Optionally also the time period of the use percentage may be specified.
Table aliases: AgriculturalUses, AgriculturalUse.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idAgriculturalUse |
AlphaNumeric(50) |
The unique identification code of the agricultural use group / plant protection product (PPP). |
idAgriculturalUse, AgriculturalUseId, Id |
Yes |
idFood |
AlphaNumeric(50) |
The food code. |
idFood, FoodId, Food |
Yes |
Location |
AlphaNumeric(50) |
The location or country code, agricultural use location. |
Country, Location |
No |
StartDate |
DateTime |
StartDate |
No |
|
EndDate |
DateTime |
EndDate |
No |
|
PercentageCropTreated |
Numeric |
The percentage agricultural use (%). |
PercentageCropTreated, Percentage, PercCropTreated, PercentageUse |
Yes |
Name |
AlphaNumeric(100) |
Name of the agricultural use. |
Name |
No |
Description |
AlphaNumeric(200) |
Additional description of the agricultural use. |
Description |
No |
Agricultural use substances
The agricultural use substances table records the substances that are part of the agricultural use mixtures (PPPs).
Table aliases: AgriculturalUseHasSubstances, AgriculturalUsesHasSubstances, AgriculturalUseSubstances, AgriculturalUseGroups, AgriculturalUseGroup.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idAgriculturalUse |
AlphaNumeric(50) |
The agricultural use code, normally a code for a combination of authorised substances. |
idAgriculturalUse, AgriculturalUseId |
Yes |
idSubstance |
AlphaNumeric(50) |
The code of the substance. |
idSubstance, SubstanceId, SubstanceCode, Substance |
Yes |