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 censored concentration measurements, this information may aid to determine whether the censored 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: Zipped CSV Excel

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.

Accepted table names: AgriculturalUses, AgriculturalUse.

Table 90 Table definition for Agricultural uses.
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).

Accepted table names: AgriculturalUseHasSubstances, AgriculturalUsesHasSubstances, AgriculturalUseSubstances, AgriculturalUseGroups, AgriculturalUseGroup.

Table 91 Table definition for Agricultural use substances.
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