ABCDEFGHIJKLMNOPQRSTUV
1
SPARQL QueryQuery DescriptionQuery Output Variables ResultsAggregate ResultsQuery Tim (Milliseconds)Query Time (seconds)
2
3
SELECT COUNT(*) WHERE { ?s ?p ?o }Count every record in the database52,256,338,367186,470186
4
SELECT COUNT(DISTINCT ?s) as ?cnt WHERE { ?s a ?o }Entity Count (i.e., subjects of isA relations)
5

SELECT COUNT(DISTINCT ?s) as ?cnt WHERE { ?s a foaf:Person }		Count of Entities of type foaf:Person502,225,23135,07535
6
SELECT COUNT(DISTINCT ?s) as ?cnt WHERE { ?s a foaf:PersonalProfileDocument }Count of Entities of type foaf:PersonalProfileDocument3,723,557279
7
SELECT ?p, COUNT(*) as ?cnt WHERE { ?s ?p ?o } ORDER BY DESC (?cnt) LIMIT 50Total Predicate/Attribute Count across all relations for all Entities in the DBMS
8
9
SELECT ?o, COUNT(?o) as ?cnt WHERE { ?s a ?o } ORDER BY DESC (?cnt) LIMIT 50Total count of all Objects/Values of isA relations (basically a count of TBox Classes with >= 1 ABox instance)
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60

SELECT COUNT(*) As ?Total
WHERE {
{?s rdf:type geo:SpatialThing} union
{?s rdf:type geo:Point} union
{?s geo:lat ?p . ?s geo:long ?p} union
{?s geo:location ?p } union
{?s geo:alt ?p} union
{?s geo:lat_long ?p }
}		Total count for entities of types: geo:SpatialThing AND geo:Point
61
62

SELECT COUNT(*) As ?Total
WHERE {
{?s rdf:type osspr:1kmGridSquare} union
{?s rdf:type osspr:20kmGridSquare} union
{?s osspr:contains ?p } union
{?s osspr:equals ?p } union
{?s osspr:oneKMGridReference ?p} union
{?s osspr:partiallyOverlaps ?p} union
{?s osspr:touches ?p} union
{?s osspr:within ?p} union
{?s osspr:twentyKMGridReference ?p }
}		Total count for entities of types: osspr:1kmGridSquare AND osspr:20KmGridSquare
63
26
64

SELECT COUNT(*) As ?Total
WHERE {
{?s rdf:type gn:Class} union
{?s rdf:type gn:Concept} union
{?s gn:featureClass ?p } union
{?s gn:featureCode ?p } union
{?s gn:parentFeature ?p} union
{?s gn:parentCountry ?p} union
{?s gn:parentADM1 ?p} union
{?s gn:parentADM2 ?p} union
{?s gn:parentADM3 ?p} union
{?s gn:parentADM4 ?p} union
{?s geo:lat ?p . ?s geo:long ?p}
}		Count of entities of type: gn:Class AND gn:Concept
65
5
66
SELECT COUNT(*) As ?Total WHERE {
{?s rdf:type osgeo:AbstractGeometry} union
{?s rdf:type admingeo:CivilAdministrativeArea} union
{?s osgeo:extent ?p } union
{?s admingeo:constituency ?p } union
{?s admingeo:county ?p} union
{?s admingeo:district ?p} union
{?s admingeo:parish ?p} union
{?s admingeo:ward ?p} union
{?s admingeo:westminsterConstituency ?p} union
{?s admingeo:inCounty ?p} union
{?s admingeo:inDistrict ?p} union
{?s admingeo:inEuropeanRegion ?p} union
{?s admingeo:inRegion ?p}
}
67