NEWS

srppphist 2.0.3

Add function last_approved() to find the year of the last occurrence of a substance in the list of registers provided here

Read in using srppp v2.0.5, in order to correct some dosage information that is incorrect or missing in older XML files.

Remove duplicate entries in srppp_substances_merged and srppp_active_substances_merged.

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.

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.

Update srppp_list and the derived data objects using srppp version 1.0.1, storing risk mitigation measures as integers instead of character, adding reference to parent cultures to the culture table, and trimming leading and trailing whitespace from descriptions
Add the convenience function product_categories(), concatenating the product categories for a specific P-Number and a specific year
Add the concatenated product categories to srppp_products, taken from the latest year that a product is contained in

Use srppp version 0.99.2 to read in the historic data. Thus, product information is now tied to the P-Number, as it turned out that sales permissions (W-Numbers with dashes) always had identical product sections with the exception of the permission holder.
Add the earliest year of appearance in the product list srppp_products, and the earliest and latest year for srppp_substances and srppp_active_substances.

Add translations of obligations for the protection of the environment (SPe 3) into codes for risk mitigation measures (distance to surface waters and biotopes, drift reduction and runoff reduction points)
Rename the package from 'psmvhist' to 'srppphist' and update the data using version 0.3.4 of the 'srppp' package.
For 2011, we now use the XML file from 31 October instead of 18 October. For 2020, we now use the XML file from 20 January instead of 16 January, as some corrections were made in these later files.
Add a table with all substances from all years 'srppp_substances', a table of products from all years 'srppp_products', and a table of active ingredient contents 'srppp_ingredients'.

The 'psmv_list' object was updated using psmv version 0.3.3, in the hope that only redundant information was removed from the ingredients table.