[OPEN-ILS-GENERAL] look for LCSH MARC records

Jane Sandberg sandbej at linnbenton.edu
Thu Nov 2 12:06:56 EDT 2017

Hi Tina,

We do the following:

* Use SQL queries to generate a list of headings in the catalog
* Use a script to pull all those headings from LOC into one huge MARC file
* Upload that MARC file into Evergreen

Here's the script we use; improvements are very welcome:

And this blog post includes the SQL queries that we use to generate
those heading lists in the first place:

It's not a perfect process, but it is free (our favorite price). :-)


On Thu, Nov 2, 2017 at 8:50 AM, Tina Ji <tina.ji at bc.libraries.coop> wrote:
> Hello everyone,
> We've been exploring authority control and planning to apply it. We have an
> old version of LCSH (over 10 years). We hope to start with a newer version.
> I found only meta records on LOC website. Downloading from LOC seems
> infeasible, considering the amount. We also do not have the budget to engage
> an vendor to do it for us now. I wonder whether anyone knows where to find
> LCSH MARC records, or anyone may share with us.
> Any information will be appreciated.
> Thank you
> Tina Ji
> --
> Tina Ji
> 1-888-848-9250 ext 1014
> Support Specialist
> BC Libraries Co-operative

Jane Sandberg
Electronic Resources Librarian
Linn-Benton Community College
sandbej at linnbenton.edu / 541-917-4655
Pronouns: she/her/hers or they/them/theirs

More information about the Open-ils-general mailing list