wiki:reportCatalogueCount2018

Report on actively used bib records by library, 2018

Running the following query counts the number of distinct bibliographic records that are associated with:

  • 1 or more copies owned by the target library system
  • 1 or more URIs (URLs for electronic resources) owned by the target library system

The report filters out deleted bib records and deleted call numbers and avoids duplicates. It is my belief that this is an accurate reflection of the number of bib records a given library would need to extract if it wanted to leave Conifer and create its own library system.

Note: If one wants to consider the number of records required for a single system (for example, all of the records required by the Laurentian campus libraries), it may be lower than the simple sum of all of the individual libraries in the system. For example, two different libraries in the same system may have attached copies to the same record.

Note: This does not count the number of records required for URIs, as the required location for those changed so that they are recorded at the system level rather than at the individual library level.

As of February 22, 2018, here's the list of libraries and the number of bib records each one currently requires:

conifer=# WITH raw AS (
conifer(#   SELECT id, conifer.count_bibs(id)
conifer(#   FROM actor.org_unit
conifer(#   WHERE (parent_ou = 1 OR ou_type IN (3,4))
conifer(#     AND opac_visible IS TRUE
conifer(# )
conifer-# SELECT aoup.name AS "Parent", aou.name, raw.count_bibs
conifer-#   FROM raw
conifer-#     INNER JOIN actor.org_unit aou ON aou.id = raw.id
conifer-#     LEFT JOIN actor.org_unit aoup ON aoup.id = aou.parent_ou
conifer-#   ORDER BY 1, 3 DESC;
                   Parent                   |                      name                       | count_bibs 
--------------------------------------------+-------------------------------------------------+------------
 Algoma System                              | Algoma University, Wishart Library              |      89010
 Algoma System                              | Lest We Forget Remembrance and Military Library |       1218
 Child and Community Resources              | CCR - Sudbury                                   |        690
 Child and Community Resources              | CCR - Thunder Bay                               |        323
 Child and Community Resources              | CCR - Sault. Ste. Marie                         |          1
 Child and Community Resources              | CCR - Fort Frances                              |          0
 Collège Boréal                             | Collège Boréal - Sudbury                        |      19758
 Collège Boréal                             | Collège Boréal - Timmins                        |       1521
 Collège Boréal                             | Collège Boréal - Toronto                        |       1178
 Collège Boréal                             | Collège Boréal - Témiskaming                    |        440
 Collège Boréal                             | Collège Boréal - Kapuskasing                    |        257
 Collège Boréal                             | Collège Boréal - Hearst                         |         97
 Collège Boréal                             | Collège Boréal - Nipissing                      |          6
 Conifer                                    | Laurentian University                           |     991202
 Conifer                                    | Algoma System                                   |     189377
 Conifer                                    | Collège Boréal                                  |      47350
 Conifer                                    | Université de Hearst                            |      38143
 Conifer                                    | Special Libraries                               |      33567
 Conifer                                    | Northern Ontario Health Library Consortium      |      21236
 Conifer                                    | Child and Community Resources                   |       1010
 Laurentian University                      | J.N. Desmarais Library                          |     434893
 Laurentian University                      | University of Sudbury                           |      26002
 Laurentian University                      | Laboratoire de didactiques, E.S.E.              |      12602
 Laurentian University                      | Huntington University Library                   |      11578
 Laurentian University                      | Music Resource Centre                           |       6555
 Laurentian University                      | School of Architecture                          |       4547
 Laurentian University                      | Centre franco-ontarien de folklore              |       2809
 Laurentian University                      | IT Service Desk                                 |        569
 Northern Ontario Health Library Consortium | HSN Health Sciences Library                     |       7388
 Northern Ontario Health Library Consortium | Northern Ontario School of Medicine (East)      |       3685
 Northern Ontario Health Library Consortium | St. Joseph's Care Group                         |       3187
 Northern Ontario Health Library Consortium | Northern Ontario School of Medicine (West)      |       2732
 Northern Ontario Health Library Consortium | Sault Area Hospital                             |       1827
 Special Libraries                          | Mining and the Environment Database             |      23211
 Special Libraries                          | Glencore Process Support Centre Library         |       4589
 Special Libraries                          | Art Gallery of Sudbury                          |       2559
 Special Libraries                          | John B. Gammon Geoscience Library               |       2377
 Special Libraries                          | Vale Inco                                       |        830
 Special Libraries                          | Northeast Mental Health Centre                  |          2
 Université de Hearst                       | Hearst, Bibliothèque Maurice-Saulnier           |      35559
 Université de Hearst                       | Hearst Timmins, Centre de Ressources            |       4592
 Université de Hearst                       | Hearst Kapuskasing, Centre de Ressources        |       2353
(42 rows)
Last modified 17 months ago Last modified on Feb 22, 2018, 11:06:40 AM