agroscope-ch/srppphist: agroscope-ch/srppphist: v2.0.0 - Historical Data from the Swiss Register of Plant Protection Products as an R Package

R package containing historical plant protection product authorisation data for Switzerland read in using srppp v2.0.4 for each year from 2011 to 2026. The description given in the package DESCRIPTION file is below:

"Data objects extracted from historical XML versions of the Swiss Register of Plant Protection Products 'SRPPP'. Starting from 2011, one such data object is contained for each year. Note that the information contained in this project is outdated. An online version of the current register can be accessed via https://www.psm.admin.ch/de/produkte. An XML dump of the current register can be read in using the 'srppp' package. There is no guarantee of correspondence of the data contained in or read in using this package with any online version, or with the original registration documents. Also, the Federal Food Safety and Veterinary Office, coordinating the authorisation of plant protection products in Switzerland, does not answer requests regarding this package."

Installation

install.packages("srppphist",
  repos = c("https://agroscope-ch.r-universe.dev", "https://cran.r-project.org"))

Documentation

An online version of the documentation of the current development version of
the package is available on github.

Since version 1.0.0, the following changes were introduced:

version 2.0.0

• Add data for 2026 from the XML file dated 3 February 2026.
• As a new primary key scheme is used for substances in the 2026 data, the lists srppp_substances and srppp_active substances, resolving primary keys to substance names now contain duplicated entries. Also, the pk column is now of type character, so it can hold the new type of primary keys formatted as a UUID.
• For these tables, new versions without duplicates are added, i.e. srppp_substances_merged and srppp_active_substances_merged. In these tables, there are two primary key columns, one called pk_v1 containing the integer primary keys from the previous format, and pk_v2 containing the primary keys from the current format, i.e. in the form of an UUID.
• The package now depends on srppp v2.0.4, which fixes a problem that occurred when reading in the register from 2015 with srppp versions 2.0.0 to 2.0.3.

version 1.0.0.9005

• Add a vignette showing cases in which products were registered under the same name that contain a different set of active ingredients.
• srppp_products, srppp_substances and similar objects: Change the type of the 'year' column to integer to have the natural representation.
• Add srppp_pests, a table of pesticide targets ("pests") extracted from all years.
• Add parallel imports to the table srppp_products. Also, add the column chNbr, holding the registration number (e.g. "W-7610-1" or "D-6918" as an example for a parallel import).
• Add data for 2025 from the XML file dated 1 April 2025, published on the website on 17 April 2025.
• Add function srppp_xml_product_use_not_authorized to find products with no active authorisation which are nevertheless present in the source XML file.
• Update srppp_list and the derived data objects using srppp version 1.1.0. This adds a culture_tree attribute to each srppp_dm object in the list. Also, duplicate ingredient specifications in the same product are now removed.
• A new table srppp_compositions was added, with only one composition for each P-Number, as opposed to srppp_ingredients, where all unique compositions are listed.
• The functions pNbr and composition were added, making it trivial to find P-Numbers from product names and compositions from P-Numbers.