CodeS are unclear

[damian-oswald]

What exactly is CodeS? We define it as a GHS precautionary statement in our documentation page, but having a look at https://en.wikipedia.org/wiki/GHS_precautionary_statements tells me that that is actually not what these codes are.

PREFIX : <https://agriculture.ld.admin.ch/plant-protection/>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX cube: <https://cube.link/>
PREFIX schema: <http://schema.org/>
SELECT DISTINCT ?name
WHERE {
  ?product a :Product ; :ghs ?code .
  ?code a <https://agriculture.ld.admin.ch/plant-protection/ghs/PrecautionaryStatement> .
  ?code schema:identifier ?name .
}

(Query can be directly executed on https://lindas.admin.ch/sparql/)

[GuySchnidrig]

@Willubilu Please elaborate and dont forget to add data documentaion file to Repo as discussed :)

[Willubilu]

Code S references the 'PSM Sätze' whitch are obligations for handling a product (linked to the product while the obligations are linked to the indication). They are not standardized and not public but managed by the ZS PSM (in INFOFITO).
in attachement de current version of the 'konzeptionelle Datenmodell' with the descriptions (not yet aproved by Damian M)

[177035312] Datenmodell PSMV.docx

[Willubilu]

although the obligations are also managed by the ZS PSM, they are stored in seperate tables from the 'PSM Sätzen' and are linked to indications, not products. The content can be overlapping.

[GuySchnidrig]

@damian-oswald we can model them sepearte to the GHS statements