ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAE
1
Ontology IRIhttp://data.esante.gouv.fr/ansm/medicament/sparnatural-config<--- Set cell B1 to the URI of your configuration ontology
2
dct:sourcehttps://docs.google.com/spreadsheets/d/1p79HqAvg5uDELeVSvgmZ1SgoDLcg59CSaw_tsbfQBUk<--- Set cell B2 to the URL of your google spreadhseet, this looks like https://docs.google.com/spreadsheets/d/xxxxxxxxxx
3
dct:formathttps://xls2rdf.sparna.fr/rest/convert?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1p79HqAvg5uDELeVSvgmZ1SgoDLcg59CSaw_tsbfQBUk%2Fexport%3Fformat%3Dxlsx&noPostProcessings=true<--- Save the result of this URL and pass it to Sparnatural as a configuration. In development phase, you can even pass this URL directly as the Sparnatural configuration.
4
dct:formathttps://docs.google.com/spreadsheets/d/1p79HqAvg5uDELeVSvgmZ1SgoDLcg59CSaw_tsbfQBUk/export?format=xlsxDon't touch any of the grey cells
5
rdf:typeowl:OntologySee the Sparnatural configuration documentation at https://docs.sparnatural.eu/OWL-based-configuration
6
owl:importshttp://data.sparna.fr/ontologies/sparnatural-config-coreSee the Spreadsheet-2-SKOS conversion service documentation at https://xls2rdf.sparna.fr/rest/convert
7
owl:importshttp://data.sparna.fr/ontologies/sparnatural-config-datasources
8
PREFIXthishttp://data.esante.gouv.fr/ansm/medicament/sparnatural-config/
9
PREFIXcorehttp://data.sparna.fr/ontologies/sparnatural-config-core#
10
PREFIXdatasourceshttp://data.sparna.fr/ontologies/sparnatural-config-datasources#
11
PREFIXmed
http://data.esante.gouv.fr/ansm/medicament/
<--- You can add more prefixes like the one above.
Default prefixes are already known: foaf, schema, owl, rdfs, etc.
See full list at https://skos-play.sparna.fr/play/convert#prefixes
12
13
14
15
URI of the class. This column can use prefixes declared above in the headerThis should **always** be owl:ClassThis should be set to core:SparnaturalClass most of the time, or rdfs:Literal when it corresponds to a literal valueEnglish label of the classFrench label of the class. Adjust the language code in the cell below to another language if needed.The Fontawesome icon code for the class, e.g. "fa-duotone fa-user". Search for icon codes at https://fontawesome.com/. Fontawesome provides a limited number of icons for free, and you can buy a license to access the full set of icons.The english tooltip for the class.The french tooltip of the class. Adjust the language code in the cell below to another language if needed.The sort order of the class in the class dropdown list. This is an integer, e.g. "1", "2", etc.The reference to a property in the configuration that will be fetched automatically when the use selects this class as a column with the eye.The corresponding pice of SPARQL to be inserted instead of the URI of this class. If not provided, the URI of the class is left intact in the query.
The SPARQL string must NOT use prefixes.
16
URIrdf:typerdfs:subClassOfrdfs:label@enrdfs:label@frcore:faIconcore:tooltip@encore:tooltip@frcore:order^^xsd:integercore:defaultLabelPropertycore:sparqlString^^xsd:string
17
Classes
18
med:Presentationowl:Classcore:SparnaturalClassPrésentationfa-thin fa-box3rdfs:label
19
med:UniteCommuneDeDispensationowl:Classcore:SparnaturalClassUCDfa-thin fa-capsules2rdfs:label
20
med:SpecialitePharmaceutiqueowl:Classcore:SparnaturalClassSpécialité pharmaceutiquefa-thin fa-pills1rdfs:label
21
med:MedicamentParSubstanceDosageForme
owl:Classcore:SparnaturalClassPhPID 4fa-thin fa-folder-medical7rdfs:label
22
med:MedicamentParSubstanceFormeowl:Classcore:SparnaturalClassPhPID 3fa-thin fa-folder-medical6rdfs:label
23
med:MedicamentParSubstanceDosageowl:Classcore:SparnaturalClassPhPID 2fa-thin fa-folder-medical5rdfs:label
24
med:MedicamentParSubstanceowl:Classcore:SparnaturalClassPhPID 1fa-thin fa-folder-medical4rdfs:label
25
med:PrescriptionEnDCowl:Classcore:SparnaturalClassPrescription en DCfa-thin fa-file-prescription8rdfs:label
26
med:GroupeGeneriqueowl:Classcore:SparnaturalClassGroupe génériquefa-thin fa-files-medical9rdfs:label
27
this:ATCowl:Classcore:SparnaturalClassATCfa-thin fa-folder-treeArdfs:label
28
med:Evenementowl:Classcore:SparnaturalClassEvènement/Autorisation
fa-thin fa-calendar-exclamation
Un évènement réglementaire : Autorisation (AMM, enregistrement, AAC, AAP, ADP, AI), affectation des indications pour les accès dérogatoires, changement de statutBrdfs:label
[ <http://www.w3.org/2000/01/rdf-schema#subClassOf> <http://data.esante.gouv.fr/ansm/medicament/Evenement> ]
29
Catégories
30
med:Substanceowl:Classcore:SparnaturalClassSubstancefa-thin fa-atom-simple9rdfs:label
31
med:Formeowl:Classcore:SparnaturalClassFormefa-thin fa-flask10rdfs:label
32
med:Voieowl:Classcore:SparnaturalClassVoie d'administrationfa-thin fa-lips11rdfs:label
33
med:UniteDePresentationowl:Classcore:SparnaturalClassUnité de présentationfa-thin fa-inhaler12rdfs:label
34
med:CategorieSpecialiteowl:Classcore:SparnaturalClassCatégorie de spécialitéfa-thin fa-book-medical13rdfs:label
35
med:TypeProcedureowl:Classcore:SparnaturalClassType de procédurefa-thin fa-list13rdfs:label
36
med:TypeEvenementowl:Classcore:SparnaturalClassType d'évènementfa-thin fa-list13rdfs:label
37
Dosages
38
med:Dosageowl:Classcore:SparnaturalClassDosagefa-thin fa-gaugerdfs:label
?dosageClass . VALUES ?dosageClass { <http://data.esante.gouv.fr/ansm/medicament/DosagePresentation> <http://data.esante.gouv.fr/ansm/medicament/DosageConcentration> }
39
med:Quantiteowl:Classrdfs:LiteralQuantité
fa-thin fa-circle-three-quarters
40
med:Uniteowl:Classrdfs:LiteralUnitéfa-thin fa-calculator
41
42
med:DosagePresQuantiteSubstowl:Classcore:SparnaturalClass
Quantité de substance (dosage présentation)
fa-regular fa-crutchmed:quantiteSubstance
<http://data.esante.gouv.fr/ansm/medicament/DosagePresentation>
43
med:DosagePresUniteSubstowl:Classcore:SparnaturalClass
Unité de quantité de substance (dosage présentation)
fa-regular fa-crutchmed:unite
<http://data.esante.gouv.fr/ansm/medicament/DosagePresentation>
44
med:DosagePresQuantiteowl:Classcore:SparnaturalClass
Quantité totale (dosage présentation)
fa-regular fa-crutchmed:quantitePresentation
<http://data.esante.gouv.fr/ansm/medicament/DosagePresentation>
45
med:DosagePresUniteowl:Classcore:SparnaturalClass
Unité de quantité totale (dosage présentation)
fa-regular fa-crutchmed:uniteQuantitePresentation
<http://data.esante.gouv.fr/ansm/medicament/DosagePresentation>
46
47
Dosage concentration
48
med:DosageConcentrationowl:Classcore:SparnaturalClassDosage concentrationfa-regular fa-crutchrdfs:label
49
med:DosageConcQuantiteowl:Classcore:SparnaturalClass
Quantité de substance (dosage concentration)
fa-regular fa-crutchmed:quantiteSubstance
<http://data.esante.gouv.fr/ansm/medicament/DosageConcentration>
50
med:DosageConcUniteowl:Classcore:SparnaturalClass
Unité de quantité de substance (dosage concentration)
fa-regular fa-crutchmed:unite
<http://data.esante.gouv.fr/ansm/medicament/DosageConcentration>
51
52
Literal
53
this:Textowl:Classrdfs:LiteralTextefa-thin fa-align-left
54
this:Dateowl:Classrdfs:LiteralDatefa-thin fa-calendar-day
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100