| | 1 | = Report on actively used bib records by library, 2020 = |
| | 2 | |
| | 3 | Running the following query counts the number of distinct bibliographic records that are associated with: |
| | 4 | |
| | 5 | * 1 or more copies owned by the target library system |
| | 6 | * 1 or more URIs (URLs for electronic resources) owned by the target library system |
| | 7 | |
| | 8 | 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. |
| | 9 | |
| | 10 | 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. |
| | 11 | |
| | 12 | 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. |
| | 13 | |
| | 14 | As of January 27, 2020, here's the list of libraries and the number of bib records each one currently requires: |
| | 15 | |
| | 16 | {{{ |
| | 17 | WITH raw AS ( |
| | 18 | SELECT id, conifer.count_bibs(id) |
| | 19 | FROM actor.org_unit WHERE (parent_ou = 1 OR ou_type IN (3,4)) |
| | 20 | AND opac_visible IS TRUE |
| | 21 | ) |
| | 22 | SELECT aoup.name AS "Parent", aou.name, raw.count_bibs |
| | 23 | FROM raw |
| | 24 | INNER JOIN actor.org_unit aou ON aou.id = raw.id |
| | 25 | LEFT JOIN actor.org_unit aoup ON aoup.id = aou.parent_ou |
| | 26 | ORDER BY 1, 3 DESC; |
| | 27 | ; |
| | 28 | |
| | 29 | Parent | name | count_bibs |
| | 30 | --------------------------------------------+-------------------------------------------------+------------ |
| | 31 | Algoma System | Algoma University, Wishart Library | 82334 |
| | 32 | Algoma System | Lest We Forget Remembrance and Military Library | 1218 |
| | 33 | Collège Boréal | Collège Boréal - Sudbury | 19897 |
| | 34 | Collège Boréal | Collège Boréal - Timmins | 1519 |
| | 35 | Collège Boréal | Collège Boréal - Toronto | 1279 |
| | 36 | Collège Boréal | Collège Boréal - Témiskaming | 440 |
| | 37 | Collège Boréal | Collège Boréal - Kapuskasing | 257 |
| | 38 | Collège Boréal | Collège Boréal - Hearst | 97 |
| | 39 | Collège Boréal | Collège Boréal - Nipissing | 6 |
| | 40 | Conifer | Laurentian University | 1025882 |
| | 41 | Conifer | Algoma System | 182707 |
| | 42 | Conifer | Collège Boréal | 47512 |
| | 43 | Conifer | Special Libraries | 33559 |
| | 44 | Conifer | Université de Hearst | 30461 |
| | 45 | Conifer | Northern Ontario Health Library Consortium | 18802 |
| | 46 | Laurentian University | J.N. Desmarais Library | 439719 |
| | 47 | Laurentian University | University of Sudbury | 23927 |
| | 48 | Laurentian University | Laboratoire de didactiques, E.S.E. | 12486 |
| | 49 | Laurentian University | Huntington University Library | 11511 |
| | 50 | Laurentian University | Music Resource Centre | 7021 |
| | 51 | Laurentian University | School of Architecture | 6841 |
| | 52 | Laurentian University | Centre franco-ontarien de folklore | 2812 |
| | 53 | Laurentian University | IT Service Desk | 550 |
| | 54 | Northern Ontario Health Library Consortium | HSN Health Sciences Library | 7176 |
| | 55 | Northern Ontario Health Library Consortium | St. Joseph's Care Group | 3305 |
| | 56 | Northern Ontario Health Library Consortium | Northern Ontario School of Medicine (West) | 2582 |
| | 57 | Northern Ontario Health Library Consortium | Northern Ontario School of Medicine (East) | 2177 |
| | 58 | Northern Ontario Health Library Consortium | Sault Area Hospital | 989 |
| | 59 | Special Libraries | Mining and the Environment Database | 23204 |
| | 60 | Special Libraries | Glencore Process Support Centre Library | 4589 |
| | 61 | Special Libraries | Art Gallery of Sudbury | 2560 |
| | 62 | Special Libraries | John B. Gammon Geoscience Library | 2377 |
| | 63 | Special Libraries | Vale Inco | 828 |
| | 64 | Special Libraries | Northeast Mental Health Centre | 2 |
| | 65 | Université de Hearst | Hearst, Bibliothèque Maurice-Saulnier | 27804 |
| | 66 | Université de Hearst | Hearst Timmins, Centre de Ressources | 4685 |
| | 67 | Université de Hearst | Hearst Kapuskasing, Centre de Ressources | 2353 |
| | 68 | (37 rows) |
| | 69 | }}} |
