864
edits
No edit summary |
|||
(10 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
This Wikibase will be used to demonstrate the current CD standard using real data. | This Wikibase will be used to demonstrate the current CD standard using real data. | ||
The data standard is currently under development. This development is | The data standard is currently under development. This development is done in [https://github.com/tdwg/cd GitHub] | ||
== Wikibase model == | == Wikibase model == | ||
Line 10: | Line 10: | ||
Not all concepts and controlled vocabulary term are already present in the Wikibase. So when adding your institutional data, it might/will be necessary to add new terms to the Wikibase. | Not all concepts and controlled vocabulary term are already present in the Wikibase. So when adding your institutional data, it might/will be necessary to add new terms to the Wikibase. | ||
== Example Queries == | == Collection modelling: example == | ||
=== Example collection === | |||
As an example, we modeled the herbarium of Meise Botanic Garden in the Wikibase. The main components of the example description are: | |||
* General description of the collection: {{Q|Q123}} | |||
* Descriptions of the collection metrics (simplified!): {{Q|128}} and {{Q|133}} | |||
* Item to represent the institute: {{Q|124}} | |||
=== Example Queries on collections === | |||
==== Get the total number of curatorial objects ==== | |||
This query gives the total amount of specimen: | |||
{{SPARQL2|query= | |||
PREFIX cd:<http://tdwg-cd.wiki.opencura.com/entity/> | |||
PREFIX cdt:<http://tdwg-cd.wiki.opencura.com/prop/direct/> | |||
PREFIX cds: <http://tdwg-cd.wiki.opencura.com/entity/statement/> | |||
PREFIX cdp: <http://tdwg-cd.wiki.opencura.com/prop/> | |||
PREFIX cdq: <http://tdwg-cd.wiki.opencura.com/prop/qualifier/> | |||
PREFIX cdps: <http://tdwg-cd.wiki.opencura.com/prop/statement/> | |||
SELECT ?item ?object ?count WHERE { | |||
?item cdt:P127 cd:Q124 . | |||
?item cdp:P15 ?statement. | |||
?statement cdps:P15 ?object. | |||
?statement cdq:P106 ?count. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
}} | |||
==== Get the total number of digitized specimen at MIDS level 1 ==== | |||
{{SPARQL2|query= | |||
PREFIX cd:<http://tdwg-cd.wiki.opencura.com/entity/> | |||
PREFIX cdt:<http://tdwg-cd.wiki.opencura.com/prop/direct/> | |||
PREFIX cds: <http://tdwg-cd.wiki.opencura.com/entity/statement/> | |||
PREFIX cdp: <http://tdwg-cd.wiki.opencura.com/prop/> | |||
PREFIX cdq: <http://tdwg-cd.wiki.opencura.com/prop/qualifier/> | |||
PREFIX cdps: <http://tdwg-cd.wiki.opencura.com/prop/statement/> | |||
SELECT ?item ?object ?count WHERE { | |||
?item cdt:P127 cd:Q124 . | |||
?item cdp:P113 ?statement. | |||
?statement cdps:P113 ?object. | |||
?statement cdq:P123 ?count. | |||
?statement cdq:P121 cd:Q120. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
}} | |||
== CD standard: Example Queries == | |||
=== Controlled vocabulary of preservation methods === | === Controlled vocabulary of preservation methods === | ||
This SPARQL query gives an overview of all preservation methods present in the wikibase. | This SPARQL query gives an overview of all preservation methods present in the wikibase. | ||
{{SPARQL2|query= | {{SPARQL2|query= | ||
PREFIX cd:< | PREFIX cd:<http://tdwg-cd.wiki.opencura.com/entity/> | ||
PREFIX cdt:< | PREFIX cdt:<http://tdwg-cd.wiki.opencura.com/prop/direct/> | ||
SELECT ?method ?methodLabel WHERE { | SELECT ?method ?methodLabel WHERE { | ||
?method cdt:P1 cd:Q41. | ?method cdt:P1 cd:Q41. | ||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
}} | |||
=== List of all Classes === | |||
This query provides you with a list of all available classes in the standard | |||
{{SPARQL2|query= | |||
PREFIX cd:<http://tdwg-cd.wiki.opencura.com/entity/> | |||
PREFIX cdt:<http://tdwg-cd.wiki.opencura.com/prop/direct/> | |||
SELECT ?class ?classLabel WHERE { | |||
?class cdt:P1 cd:Q6. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | |||
} | |||
}} | |||
=== List of all properties belonging to the ObjectGroup Class === | |||
This query creates a list of all properties belonging to the ObjectGroup class | |||
{{SPARQL2|query= | |||
PREFIX cd:<http://tdwg-cd.wiki.opencura.com/entity/> | |||
PREFIX cdt:<http://tdwg-cd.wiki.opencura.com/prop/direct/> | |||
SELECT ?prop ?propLabel WHERE { | |||
?prop cdt:P3 cd:Q3. | |||
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } | ||
} | } | ||
}} | }} |