We defined a lot of useful statistics queries for datasets in §6.6 of the W3C HCLS Dataset Description Guidelines https://www.w3.org/TR/hcls-dataset/#s6_6
I’ve made these available in a GitHub repo https://github.com/AlasdairGray/HCLS-Stats-Queries Hopefully you find these helpful Alasdair -- Alasdair J G Gray Associate Professor in Computer Science, School of Mathematical and Computer Sciences Heriot-Watt University, Edinburgh, UK. Email: a.j.g.g...@hw.ac.uk<mailto:a.j.g.g...@hw.ac.uk> Web: http://www.macs.hw.ac.uk/~ajg33 ORCID: http://orcid.org/0000-0002-5711-4872 Office: Earl Mountbatten Building 1.39 Twitter: @gray_alasdair Heriot-Watt is a global University, as a result my working hours may not be your working hours. Do not feel pressure to reply to this email outside your working hours. To arrange a meeting: https://outlook.office365.com/owa/calendar/alasdairg...@heriotwatt.onmicrosoft.com/bookings/ From: Nicola Vitucci <nicola.vitu...@gmail.com> Date: Monday, 24 January 2022 at 23:21 To: users@jena.apache.org <users@jena.apache.org> Subject: Re: Trying to count the properties used for each class **************************************************************** Caution: This email originated from a sender outside Heriot-Watt University. Do not follow links or open attachments if you doubt the authenticity of the sender or the content. **************************************************************** Hey Bob, does this one do what you're after? SELECT DISTINCT ?cl (COUNT(DISTINCT ?p) AS ?c) WHERE { ?s a ?cl . ?s ?p ?o . } GROUP BY ?cl Nicola Il giorno lun 24 gen 2022 alle ore 23:05 Bob DuCharme <b...@snee.com> ha scritto: > Using arq and the data at > http://www.snee.com/bobdc.blog/files/BeatlesMusicians.ttl, I’m trying to > write a query that will list the classes used in the data and the number > of distinct properties used by instances of that class. I’m having a > hard time and can’t even write a query that lists the number of > properties used for just one of the classes; the following just shows me > a series of ones. > > SELECT (COUNT(DISTINCT ?p) AS ?pcount) > WHERE { > ?s a <http://learningsparql.com/ns/schema/Song> . > ?s ?p ?o . > } > GROUP BY ?p > > Any suggestions? > > Thanks, > > Bob > > ________________________________ Founded in 1821, Heriot-Watt is a leader in ideas and solutions. With campuses and students across the entire globe we span the world, delivering innovation and educational excellence in business, engineering, design and the physical, social and life sciences. This email is generated from the Heriot-Watt University Group, which includes: 1. Heriot-Watt University, a Scottish charity registered under number SC000278 2. Heriot- Watt Services Limited (Oriam), Scotland's national performance centre for sport. Heriot-Watt Services Limited is a private limited company registered is Scotland with registered number SC271030 and registered office at Research & Enterprise Services Heriot-Watt University, Riccarton, Edinburgh, EH14 4AS. The contents (including any attachments) are confidential. If you are not the intended recipient of this e-mail, any disclosure, copying, distribution or use of its contents is strictly prohibited, and you should please notify the sender immediately and then delete it (including any attachments) from your system.
