Changes between Version 4 and Version 5 of CMD2RDF/Queries

Timestamp:

05/23/14 15:59:54 (10 years ago)

Author:

xnrn@gmx.net

Comment:

added query for data categories

CMD2RDF/Queries

@@ -18 +18 @@
 ORDER BY DESC(?count)
 }}}
-[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0A%0A%0ASELECT%20SAMPLE%28%3Fp%29%20as%20%20%3Fprofile%20SAMPLE%28%3Fpid%29%20as%20%3Fpid%20COUNT%28%3Fi%29%20as%20%3Fcount%20WHERE%20{%20%3Fp%20rdfs%3AsubClassOf%20cmdm%3AProfile.%20%0A%3Fp%20dcterms%3Aidentifier%20%3Fpid.%0A%3Fi%20a%20%3Fp.%0A%20}%0AGROUP%20by%20%3Fp%20%3Fpid%0AORDER%20BY%20DESC%28%3Fcount%29&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=false|result in clarin.aac.ac.at-virtuoso]], 
-[[http://clarin.aac.ac.at/isparql/view/?query=PREFIX%20cmdm%3A%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0A%0ASELECT%20%3Fp%20WHERE%20{%20%3Fp%20rdfs%3AsubClassOf%20cmdm%3AProfile%20}&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=true|​just profiles]]
+[[http://clarin.aac.ac.at/virtuoso/sparql?default-graph-uri=&query=PREFIX+cmdm%3A+%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0D%0A%0D%0ASELECT+SAMPLE%28%3Fp%29+as++%3Fprofile+SAMPLE%28%3Fpid%29+as+%3Fpid+COUNT%28%3Fi%29+as+%3Fcount+WHERE+{+%3Fp+rdfs%3AsubClassOf+cmdm%3AProfile.+%0D%0A%3Fp+dcterms%3Aidentifier+%3Fpid.%0D%0A%3Fi+a+%3Fp.%0D%0A+}%0D%0AGROUP+by+%3Fp+%3Fpid%0D%0AORDER+BY+DESC%28%3Fcount%29&format=text%2Fhtml&timeout=0&debug=on|result in clarin.aac.ac.at-virtuoso]], 
+[[http://clarin.aac.ac.at/virtuoso/sparql?default-graph-uri=&query=PREFIX+cmdm%3A+%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23%3E%0D%0A%0D%0ASELECT+%3Fp+WHERE+{+%3Fp+rdfs%3AsubClassOf+cmdm%3AProfile+}&format=text%2Fhtml&timeout=0&debug=on|​just profiles]]
 
 List the `cmdm:contains` relation pairs,
@@ -36 +36 @@
 [[http://clarin.aac.ac.at/isparql/view/?query=SELECT%20%28SAMPLE%28%3Ft1%29%20AS%20%3FPARENT%29%20%28SAMPLE%28%3Ft2%29%20AS%20%3FCHILD%29%20%28COUNT%28%3Fc2%29%20as%20%3FCOUNT%29%0AWHERE%20{%20%0A%20%20%20%3Fc1%20%3Chttp%3A%2F%2Fwww.clarin.eu%2Fcmd%2Fgeneral.rdf%23contains%3E%20%3Fc2.%0A%20%20%20%3Fc1%20a%20%3Ft1.%20%3Fc2%20a%20%3Ft2.%0A%20}%20%0AGROUP%20BY%20%3Ft1%20%3Ft2%0AORDER%20BY%20%3Ft1%20%3Ft2&endpoint=%2Fsparql&maxrows=50&timeout=&default-graph-uri=&view=1&amode=0&raw_iris=false|result]]
 
+== Inspect use of data categories
+
+List all used datcats:
+{{{
+#!sql
+PREFIX dcr: <http://www.isocat.org/ns/dcr.rdf#>
+SELECT distinct ?datcat WHERE {[] dcr:datcat ?datcat}
+}}}
 
 == Inspect instance data