This data model describes the data of the Swiss registry for plant production products. It is supposed to help the reader understand the data. The actual data is available on the linked data service LINDAS.
NOTE: This is filler text. Proper introduction needs to be written, still.
The data model in this document describes the data of the Swiss registry of plant protection products (SRPPP), encoded via the Shapes Constraint Language (SHACL).
Fundamentally, the data model describes plant protection products and their attributes.
All data described in this SHACL data model in is hosted on LINDAS (Linked Data Service), the semantic web infrastructure of the Swiss federal government. The complete, dynamically updated dataset resides at https://lindas.admin.ch/. To interact with this knowledge graph, practitioners must employ the SPARQL Protocol and RDF Query Language. Querying the LINDAS endpoint allows users to execute highly specific, multi-dimensional graph traversals.
An introductory query is provided below to demonstrate the fundamental semantic extraction of arbitrary triples:
PREFIX : <https://agriculture.ld.admin.ch/plant-protection/>
PREFIX country: <https://ld.admin.ch/country/>
PREFIX schema: <http://schema.org/>
SELECT *
FROM <https://lindas.admin.ch/foag/plant-protection>
WHERE {
?product a :ParallelImport ;
schema:name ?name ;
schema:countryOfOrigin country:DEU ;
:federalAdmissionNumber ?wNumber .
}
LIMIT 10
To run this query, you may visit the LINDAS SPARQL GUI.
However, to fully leverage the analytical capabilities of this schema, users are directed to the centralized query repository. A comprehensive suite of advanced SPARQL query templates, demonstrating complex relational extraction and data aggregation, is maintained within the project's source control at https://github.com/BLV-OSAV-USAV/PSMV-RDF/tree/main/src/sparql/examples.
https://agriculture.ld.admin.ch/plant-protection/shape/ProductRepresents any plant protection product that is officially registered and listed on https://psm.admin.ch/. It serves as the abstract base class encompassing all regular products, sale permissions, and parallel imports.
^https://agriculture\.ld\.admin\.ch/plant-protection/product/.+$https://agriculture.ld.admin.ch/plant-protection/product/01967F79-C3AA-4417-BBEB-89B678003DD8| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Name | schema:name |
xsd:string |
1..1
|
Name of the product |
| Exhaustion deadline | :exhaustionDeadline |
xsd:date |
0..1
|
The date by which the product must no longer be used, typically after the product registration has been revoked. |
| Soldout deadline | :soldOutDeadline |
xsd:date |
0..1
|
The date by which the product can no longer be sold, typically after the product registration has been revoked |
| Ingredient | :ingredient |
Ingredient |
1..*
|
|
| Permission holder | :permissionHolder |
Organization |
1..1
|
The legal entity authorized to place the product on the market [...]. |
| GHS code | :ghs |
GHS statement |
0..*
|
The Globally Harmonized System of Classification and Labelling of Chemicals (GHS) hazard and precautionary statements. |
| Producing country | schema:countryOfOrigin |
country:CHE, country:DEU, country:ITA, country:FRA, country:AUT, country:BEL |
1..1
|
The country where a plant protection product was produced. |
| Indications | :indication |
Indication |
0..*
|
The indications outlining allowed applications. |
https://agriculture.ld.admin.ch/plant-protection/shape/RegularProductA plant protection product with a standard Swiss authorisation. This represents the primary admission granted by the federal authorities, acting as the foundation for derivative market permissions.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Regular product | ||||
| Federal admission number | :federalAdmissionNumber |
xsd:string^[A-Z]-[0-9]{1,4}(-[0-9]{1,2})?$ |
1..1
|
An identifier assigned by the FSVO that uniquely identifies an admissions of a plant protection product. |
| Properties from Product | ||||
| Name | schema:name |
xsd:string |
1..1
|
Name of the product |
| Exhaustion deadline | :exhaustionDeadline |
xsd:date |
0..1
|
The date by which the product must no longer be used, typically after the product registration has been revoked. |
| Soldout deadline | :soldOutDeadline |
xsd:date |
0..1
|
The date by which the product can no longer be sold, typically after the product registration has been revoked |
| Ingredient | :ingredient |
Ingredient |
1..*
|
|
| Permission holder | :permissionHolder |
Organization |
1..1
|
The legal entity authorized to place the product on the market [...]. |
| GHS code | :ghs |
GHS statement |
0..*
|
The Globally Harmonized System of Classification and Labelling of Chemicals (GHS) hazard and precautionary statements. |
| Producing country | schema:countryOfOrigin |
country:CHE, country:DEU, country:ITA, country:FRA, country:AUT, country:BEL |
1..1
|
The country where a plant protection product was produced. |
| Indications | :indication |
Indication |
0..*
|
The indications outlining allowed applications. |
https://agriculture.ld.admin.ch/plant-protection/shape/SalePermissionPermission to market a plant protection product under an alternative nomenclature based on an existing regular authorisation. The legality of this permission is inextricably linked to the validity of the underlying basic authorisation pursuant to PSMV Art. 66.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Sale Permission | ||||
| Federal admission number | :federalAdmissionNumber |
xsd:string^[A-Z]-[0-9]{4}(-[0-9]{1,2})?$ |
1..1
|
An identifier assigned by the FSVO that uniquely identifies an admissions of a plant protection product. |
| Properties from Product | ||||
| Name | schema:name |
xsd:string |
1..1
|
Name of the product |
| Exhaustion deadline | :exhaustionDeadline |
xsd:date |
0..1
|
The date by which the product must no longer be used, typically after the product registration has been revoked. |
| Soldout deadline | :soldOutDeadline |
xsd:date |
0..1
|
The date by which the product can no longer be sold, typically after the product registration has been revoked |
| Ingredient | :ingredient |
Ingredient |
1..*
|
|
| Permission holder | :permissionHolder |
Organization |
1..1
|
The legal entity authorized to place the product on the market [...]. |
| GHS code | :ghs |
GHS statement |
0..*
|
The Globally Harmonized System of Classification and Labelling of Chemicals (GHS) hazard and precautionary statements. |
| Producing country | schema:countryOfOrigin |
country:CHE, country:DEU, country:ITA, country:FRA, country:AUT, country:BEL |
1..1
|
The country where a plant protection product was produced. |
| Indications | :indication |
Indication |
0..*
|
The indications outlining allowed applications. |
https://agriculture.ld.admin.ch/plant-protection/shape/ParallelImportPlacing a plant protection product with a foreign authorisation onto the market, predicated on an equivalent reference product already authorised in Switzerland. The continued validity of this import permission requires the parallel validity of the domestic reference product (PSMV Art. 47 Abs. 1).
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Parallel Import | ||||
| Foreign admission number | :foreignAdmissionNumber |
xsd:string |
0..*
|
An identifier assigned by any foreign authority. |
:referenceProduct |
Product |
1..1
|
||
| Federal admission number | :federalAdmissionNumber |
xsd:string^[A-Z]-[0-9]{4}(-[0-9]{1,2})?$ |
1..1
|
An identifier assigned by the FSVO that uniquely identifies an admissions of a plant protection product. |
| Properties from Product | ||||
| Name | schema:name |
xsd:string |
1..1
|
Name of the product |
| Exhaustion deadline | :exhaustionDeadline |
xsd:date |
0..1
|
The date by which the product must no longer be used, typically after the product registration has been revoked. |
| Soldout deadline | :soldOutDeadline |
xsd:date |
0..1
|
The date by which the product can no longer be sold, typically after the product registration has been revoked |
| Ingredient | :ingredient |
Ingredient |
1..*
|
|
| Permission holder | :permissionHolder |
Organization |
1..1
|
The legal entity authorized to place the product on the market [...]. |
| GHS code | :ghs |
GHS statement |
0..*
|
The Globally Harmonized System of Classification and Labelling of Chemicals (GHS) hazard and precautionary statements. |
| Producing country | schema:countryOfOrigin |
country:CHE, country:DEU, country:ITA, country:FRA, country:AUT, country:BEL |
1..1
|
The country where a plant protection product was produced. |
| Indications | :indication |
Indication |
0..*
|
The indications outlining allowed applications. |
https://agriculture.ld.admin.ch/plant-protection/shape/OrganizationRepresents a legally recognized entity or organization involved in the lifecycle of a plant protection product. This encompasses administrative and commercial actors such as authorisation holders, primary manufacturers, or registered distributors.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Address | schema:address |
Address |
1..1
|
The primary postal address of the organization. |
schema:email |
xsd:string^[a-zA-Z0-9._%+\-]+@[a-zA-Z0-9.\-]+\.[a-zA-Z]{2,}$ |
0..*
|
An electronic mail address associated with the organization. The validation pattern enforces an approximation of the RFC 5322 specification syntax for internet message formats. | |
| Fax number | schema:faxNumber |
xsd:string^\+?[0-9\s\-()]{7,20}$ |
0..*
|
A facsimile number associated with the organization. The validation pattern accommodates a flexible subset of the ITU-T E.164 recommendation, permitting common typographic separators. |
| Legal name | schema:legalName |
Literal |
1..*
|
The official, legally registered name of the organization. |
| Telephone | schema:telephone |
xsd:string^\+?[0-9\s\-()]{7,20}$ |
0..*
|
A telephone number associated with the organization. The validation pattern accommodates a flexible subset of the ITU-T E.164 recommendation, permitting common typographic separators such as spaces and hyphens. |
https://agriculture.ld.admin.ch/plant-protection/shape/PostalAddressDefines the physical or postal routing information for an organization. It encapsulates granular fields required for proper geospatial identification, including country, specific street, postal routing code, and locality.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Address country | schema:addressCountry |
IRI^https://ld\.admin\.ch/country/[A-Z0-9]{3}$ |
0..1
|
|
| Address locality | schema:addressLocality |
xsd:string |
0..1
|
|
| Postal code | schema:postalCode |
xsd:string |
0..1
|
|
| Street address | schema:streetAddress |
xsd:string |
0..1
|
https://agriculture.ld.admin.ch/plant-protection/shape/ClassProperty| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| English name | schema:name |
1..*
|
Preferred name of the class or property in English | |
| Name | schema:name |
0..*
|
||
| Description | schema:description |
0..*
|
||
rdfs:comment |
0..0
|
|||
rdfs:label |
0..0
|
https://agriculture.ld.admin.ch/plant-protection/shapes/IngredientSubstanceAndShareShape| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
:share |
:shapes/ShareShape |
1..*
|
||
:substance |
Substance |
1..1
|
https://agriculture.ld.admin.ch/plant-protection/shapes/NoRdfsAnnotationsShape| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
rdfs:comment |
0..0
|
|||
rdfs:label |
0..0
|
https://agriculture.ld.admin.ch/plant-protection/shapes/OntologyDocumentationShape| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
schema:description |
0..*
|
|||
schema:name |
0..*
|
|||
schema:name |
1..*
|
https://agriculture.ld.admin.ch/plant-protection/shapes/OrganizationShape| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
schema:legalName |
xsd:string |
1..*
|
https://agriculture.ld.admin.ch/plant-protection/shapes/ProductAdmissionAndIngredientShape| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
:federalAdmissionNumber |
xsd:string^[A-Z]-[0-9]{1,4}(-[0-9]{1,2})?$ |
1..1
|
||
:ingredient |
:shapes/IngredientShape |
1..*
|
||
:permissionHolder |
:shapes/OrganizationShape |
1..1
|
https://agriculture.ld.admin.ch/plant-protection/shapes/QuantitativeValueUnitAndPositiveValueShape| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
schema:unitCode |
1..1
|
|||
schema:value |
0..*
|
https://agriculture.ld.admin.ch/plant-protection/shape/ApplicationAreaEstablishes the macro-environmental or physical operational theater in which a product's usage is legally authorized. Common delineations include enclosed greenhouse environments, open agricultural fields, or specialized storage facilities.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Name | schema:name |
3..*
|
https://agriculture.ld.admin.ch/plant-protection/shape/ApplicationCommentCaptures precise textual directives and technical stipulations regarding the physical deployment of a product. These annotations often clarify exceptional conditions, temporal constraints, or best-practice methodologies necessary for efficacy.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Description | schema:description |
3..*
|
https://agriculture.ld.admin.ch/plant-protection/shape/CultivationDenotes the specific agronomic crop, botanical grouping, or agricultural setting targeted for treatment. It forms the biological jurisdiction defining where the product may be legally utilized.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Name | schema:name |
3..*
|
https://agriculture.ld.admin.ch/plant-protection/shape/GHSStatementEncodes a standardized hazard or precautionary directive derived from the Globally Harmonized System of Classification and Labelling of Chemicals.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Identifier | schema:identifier |
xsd:string |
0..1
|
The official alphanumeric GHS identifier code. |
| Name | schema:name |
rdf:langString |
1..*
|
The localized text of the GHS statement. |
https://agriculture.ld.admin.ch/plant-protection/shape/HazardPictogramA graphical composition intended to convey specific hazard information.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Hazard pictogram | ||||
| Image | schema:image |
IRI |
1..1
|
The URI pointing to the visual representation of the pictogram. |
schema:identifier |
^GHS0[1-9]$ |
1..*
|
||
| Properties from GHS statement | ||||
| Identifier | schema:identifier |
xsd:string |
0..1
|
The official alphanumeric GHS identifier code. |
| Name | schema:name |
rdf:langString |
1..*
|
The localized text of the GHS statement. |
https://agriculture.ld.admin.ch/plant-protection/shape/HazardStatementA standard phrase assigned to a hazard class and category that describes the nature of the hazards.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Hazard statement | ||||
schema:identifier |
^H\S*$ |
1..1
|
||
| Properties from GHS statement | ||||
| Identifier | schema:identifier |
xsd:string |
0..1
|
The official alphanumeric GHS identifier code. |
| Name | schema:name |
rdf:langString |
1..*
|
The localized text of the GHS statement. |
https://agriculture.ld.admin.ch/plant-protection/shape/IndicationThe indication formally outlines an approved, highly specific usage profile for a plant protection product. It systematically links a target pest with the applicable cultivation domain and delineates parameters like dosage, legal obligations, and mandatory waiting periods.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Application Area | :applicationArea |
Application Area |
1..1
|
|
| Application Comment | :applicationComment |
Application Comment |
0..*
|
|
| Cultivation | :cultivation |
Cultivation |
1..*
|
|
| Dosage | :dosage |
Quantitative value |
0..1
|
|
| Expenditure | :expenditure |
Quantitative value |
0..1
|
|
| Obligation | :obligation |
Obligation |
0..*
|
|
| Pest | :pest |
Pest |
1..*
|
|
| Waiting Period | :waitingPeriod |
Quantitative value |
0..1
|
https://agriculture.ld.admin.ch/plant-protection/shape/IngredientRepresents a constituent component of a product. It specifies both the underlying chemical or biological substance and its corresponding quantitative share within the final formulation.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Share (Quantitative Value) | :share |
Quantitative value |
1..*
|
|
| Substance | :substance |
Substance |
1..1
|
https://agriculture.ld.admin.ch/plant-protection/shape/ObligationSpecifies statutory mandates, restrictions, or operational conditions that an applicator must strictly observe. These parameters are designed to mitigate environmental impact, safeguard human health, and ensure regulatory compliance.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Description | schema:description |
3..*
|
https://agriculture.ld.admin.ch/plant-protection/shape/PestIdentifies the pathogenic, competitive, or destructive organism—such as an insect species, fungal strain, or weed profile—that the corresponding plant protection product is engineered to neutralize or suppress.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Name | schema:name |
3..*
|
https://agriculture.ld.admin.ch/plant-protection/shape/PrecautionaryStatementA phrase that describes recommended measures to minimize or prevent adverse effects.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Precautionary statement | ||||
schema:identifier |
^P\S*$ |
1..1
|
||
| Properties from GHS statement | ||||
| Identifier | schema:identifier |
xsd:string |
0..1
|
The official alphanumeric GHS identifier code. |
| Name | schema:name |
rdf:langString |
1..*
|
The localized text of the GHS statement. |
https://agriculture.ld.admin.ch/plant-protection/shape/QuantitativeValueRepresents a measurable quantity, providing a strict numerical value coupled with its corresponding unit of measurement. It is routinely utilized to quantify precise attributes such as application dosages, required waiting periods, or formulation concentrations.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Display text | schema:name |
rdf:langString |
0..1
|
The quantitative value in textual form as it was originally written in the admission documents. |
| Unit | schema:unitCode |
1..1
|
||
| Value | schema:value |
xsd:decimal |
0..1
|
https://agriculture.ld.admin.ch/plant-protection/shape/SignalWordA word used to indicate the relative level of severity of hazard and alert the reader to a potential hazard on the label.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Properties from Signal word | ||||
schema:identifier |
0..0
|
|||
| Properties from GHS statement | ||||
| Identifier | schema:identifier |
xsd:string |
0..1
|
The official alphanumeric GHS identifier code. |
| Name | schema:name |
rdf:langString |
1..*
|
The localized text of the GHS statement. |
https://agriculture.ld.admin.ch/plant-protection/shape/SubstanceDenotes the foundational chemical entity or active biological agent embedded within a formulation. It abstracts the physical formulation to reference the fundamental molecule or organism responsible for the product's protective action.
| Property name | URI | Expected value | Card. | Description |
|---|---|---|---|---|
| Name | schema:name |
3..*
|