Main Page: Difference between revisions

1,303 bytes added ,  4 years ago
Line 18: Line 18:


=== Example Queries on collections ===
=== Example Queries on collections ===
==== Proportion of items digitized over total number of items ====
==== Get the total number of curatorial objects ====
This query gives the relative amount of digitized specimen
This query gives the total amount of specimen:
 
{{SPARQL2|
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|
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 ==
== CD standard: Example Queries ==