wiki:reportCatalogueCount2013

Report on actively used bib records by library, 2013

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.

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 or URIs to the same record.

As of March 15, 2013, here's the list of libraries and the number of bib records each one currently requires:

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


id  |  shortname  | count_bibs_by_ou 
-----+-------------+------------------
   1 | CONIFER     |                0
 102 | LAURSYS     |                0
 103 | OSUL        |           539829
 104 | HUNTINGTON  |            10443
 105 | LUSYS       |           395073
 106 | WINDSYS     |           475423
 107 | SUDBURY     |            29461
 108 | MEDIACEN    |             1018
 109 | OWA         |           872680
 110 | NOSME       |             3473
 111 | ALGOMASYS   |            97896
 112 | ARTGALL     |             2557
 113 | CFOF        |             2512
 114 | HEARSTSYS   |                0
 115 | HSN         |             7026
 116 | SAH         |             2135
 117 | MEDB        |            23397
 118 | MNDM        |             2366
 119 | XSTRATA     |             4501
 120 | VALE        |              830
 122 | OWAL        |            80628
 123 | NEMHC       |                0
 124 | OSTMA       |            99540
 125 | OSM         |             3292
 126 | NOSMW       |             2947
 127 | HEARST      |            35035
 128 | KAP         |             2207
 129 | TIMMINS     |             3678
 130 | CRC         |             4628
 131 | MRC         |             5974
 132 | LDCR        |             7674
 133 | SJCG        |             2472
 134 | LWFRML      |              272
 135 | BOREALSYS   |            26255
 136 | OSBO        |            19883
 137 | HEBOREAL    |               91
 138 | KABOREAL    |              245
 139 | NLBOREAL    |              308
 140 | NPBOREAL    |                1
 141 | TIBOREAL    |             1405
 142 | TOCARBOREAL |             1023
 144 | CHILDCARE   |                0
 145 | CCRSUDBURY  |              588
 146 | CCRSSM      |                1
 147 | CCRTBAY     |              193
 148 | CCRFORT     |                0
 149 | NBRHC       |              892
(47 rows)
Last modified 7 years ago Last modified on Mar 15, 2013, 11:50:18 AM