Report on actively used bib records by library, 2012

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

• 1 or more copies owned by the target library
• 1 or more URIs owned by the target library

The report filters out deleted bib records, deleted call numbers, and deleted copies. 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.

SELECT id, shortname, scratchpad.count_bibs_by_ou(id)
  FROM actor.org_unit
  ORDER BY id;

conifer=# SELECT name, id, shortname, scratchpad.count_bibs_by_ou(id) AS "Bibs per library" FROM actor.org_unit ORDER BY id;
                      name                       | id  |   shortname   | Bibs per library
-------------------------------------------------+-----+---------------+------------------
 Conifer                                         |   1 | CONIFER       |                0
 Special Libraries                               | 102 | LAURSYS       |                0
 J.N. Desmarais Library                          | 103 | OSUL          |           536366
 Huntington University Library                   | 104 | HUNTINGTON    |            10131
 Laurentian University                           | 105 | LUSYS         |           198460
 Windsor System                                  | 106 | WINDSYS       |           220622
 University of Sudbury                           | 107 | SUDBURY       |            29932
 Instructional Media Centre                      | 108 | MEDIACEN      |             1105
 Leddy Library                                   | 109 | OWA           |           860376
 Northern Ontario School of Medicine (East)      | 110 | NOSME         |             3360
 Algoma System                                   | 111 | ALGOMASYS     |            85920
 Art Gallery of Sudbury                          | 112 | ARTGALL       |             2557
 Centre Franco-Ontarien de Folklore              | 113 | CFOF          |             2512
 Université de Hearst                            | 114 | HEARSTSYS     |                0
 HRSRH Health Sciences Library                   | 115 | HRSRH         |             6351
 Sault Area Hospital                             | 116 | SAH           |             2045
 Mining and the Environment Database             | 117 | MEDB          |            23397
 John B. Gammon Geoscience Library               | 118 | MNDM          |             2366
 Xstrata Process Support Centre Library          | 119 | XSTRATA       |             4424
 Vale Inco                                       | 120 | VALE          |              830
 Paul Martin Law Library                         | 122 | OWAL          |            79686
 Northeast Mental Health Centre                  | 123 | NEMHC         |                0
 Algoma University, Wishart Library              | 124 | OSTMA         |            99600
 Northern Ontario School of Medicine             | 125 | OSM           |             3220
 Northern Ontario School of Medicine (West)      | 126 | NOSMW         |             2922
 Hearst, Bibliothèque Maurice-Saulnier           | 127 | HEARST        |            31298
 Hearst Kapuskasing, Centre de Ressources        | 128 | KAP           |             2087
 Hearst Timmins, Centre de Ressources            | 129 | TIMMINS       |             3352
 Curriculum Resource Centre                      | 130 | CRC           |             4455
 Music Resource Centre                           | 131 | MRC           |             5959
 Laboratoire de didactiques, E.S.E.              | 132 | LDCR          |             7973
 St. Joseph's Care Group                         | 133 | SJCG          |             2261
 Lest We Forget Remembrance and Military Library | 134 | LWFRML        |               68
 Collège Boréal                                  | 135 | BOREALSYS     |            26255
 Collège Boréal - Sudbury                        | 136 | OSBO          |            20013
 Collège Boréal - Hearst                         | 137 | HEBOREAL      |               89
 Collège Boréal - Kapuskasing                    | 138 | KABOREAL      |              239
 Collège Boréal - New Liskeard                   | 139 | NLBOREAL      |              637
 Collège Boréal - Nipissing                      | 140 | NPBOREAL      |                2
 Collège Boréal - Timmins                        | 141 | TIBOREAL      |             1432
 Collège Boréal - Toronto (Carlaw)               | 142 | TOCARBOREAL   |             1046
 Collège Boréal - Toronto (22 College)           | 143 | TO22COLBOREAL |               83
(42 rows)

Dan Scott, 2012-03-13