Rebecca Sutton Koeser bio photo

Rebecca Sutton Koeser

Lead Developer at Princeton University Center for Digital Humanities, PhD in English Literature.

Twitter LinkedIn Github ORCID iD Keybase Humanities Commons

I just figured out how to do a count query in iTQL (one of the triple query languages for the triplestore that we’re using with Fedora) and want to document it so I don’t lose it. This returns a list of content models and the number of active objects for each cmodel.

select $cmodel
count(select $item from <#ri>
where $item <info:fedora/fedora-system:def/model#hasModel> $cmodel
and $item <info:fedora/fedora-system:def/model#state> <fedora-model:Active>)
from <#ri>
where $item <info:fedora/fedora-system:def/model#hasModel> $cmodel
having $k0 <http://mulgara.org/mulgara#occursMoreThan> '0.0'^^<http://www.w3.org/2001/XMLSchema#double> ;

Current totals for Fedora staging (where we have been testing the LSDI ingest - see the ScannedBook and ScannedVolume totals):

  • info:fedora/emory-control:EtdFile-1.0, 1218
  • info:fedora/fedora-system:FedoraObject-3.0, 6772
  • info:fedora/emory-control:Hierarchy-1.0, 1
  • info:fedora/emory-control:SmallpoxRecord-1.0, 354
  • info:fedora/emory-control:SmallpoxImage-1.0, 207
  • info:fedora/emory-control:ETD-1.0, 443
  • info:fedora/emory-control:Collection-1.0, 14
  • info:fedora/emory-control:AuthorInformation-1.0, 458
  • info:fedora/emory-control:SmallpoxMSWord-1.0, 79
  • info:fedora/emory-control:SmallpoxVideo-1.0, 80
  • info:fedora/emory-control:SmallpoxAudio-1.0, 18
  • info:fedora/fedora-system:ContentModel-3.0, 16
  • info:fedora/fedora-system:ServiceDefinition-3.0, 10
  • info:fedora/fedora-system:ServiceDeployment-3.0, 10
  • info:fedora/emory-control:ScannedVolume-1.0, 2565
  • info:fedora/emory-control:ScannedBook-1.0, 1680

Just for fun, current totals for Fedora in production:

  • info:fedora/emory-control:EtdFile-1.0, 1469
  • info:fedora/fedora-system:FedoraObject-3.0, 2960
  • info:fedora/emory-control:Hierarchy-1.0, 1
  • info:fedora/emory-control:SmallpoxRecord-1.0, 354
  • info:fedora/emory-control:SmallpoxImage-1.0, 207
  • info:fedora/emory-control:ETD-1.0, 524
  • info:fedora/emory-control:Collection-1.0, 8
  • info:fedora/emory-control:AuthorInformation-1.0, 572
  • info:fedora/emory-control:SmallpoxMSWord-1.0, 79
  • info:fedora/emory-control:SmallpoxVideo-1.0, 80
  • info:fedora/emory-control:SmallpoxAudio-1.0, 18
  • info:fedora/fedora-system:ContentModel-3.0, 14
  • info:fedora/fedora-system:ServiceDefinition-3.0, 10
  • info:fedora/fedora-system:ServiceDeployment-3.0, 9

related resources: