transforming and enhancing metadata for enduser discovery...
TRANSCRIPT
![Page 1: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/1.jpg)
Transforming and enhancing metadata for enduser discovery: a case study
Edward M. Corrado Director of Library Technology [email protected]
Rachel Jaffe Metadata Catalog Librarian [email protected]
![Page 2: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/2.jpg)
Binghamton University, one of four comprehensive doctoral research universities within the State University of New York, is recognized for
stellar academics, an international focus, high graduation rates and overall value.
• Undergraduates: 12,356 • Graduate students: 2,952 • Average SAT score range: 1220-1385 • Average ACT score range: 27-30 • Top 25% of high school class: 87.9% • In the past 10 years, 91% of freshmen returned for their sophomore year • Students of color: 28% • International students: 15% Students come from 45 states and 100 countries
Binghamton University (SUNY)
![Page 3: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/3.jpg)
Digital Preservation & Resource Discovery @ Binghamton
Discovery Layer
Primo Central Digital
Preservation System
ILS
![Page 4: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/4.jpg)
Digital Projects @ Binghamton
![Page 5: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/5.jpg)
Digital Projects @ Binghamton
Metadata
Metadata
Metadata
![Page 6: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/6.jpg)
University Photographs Collection: University Photographer’s Workflow
![Page 7: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/7.jpg)
University Photographs Collection: University Photographer’s Workflow
![Page 8: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/8.jpg)
Overview of the Libraries’ Workflow Initial Set-up
Create metadata form and DC mapping table in the preservation system; create keyword & creator mapping tables
Metadata Librarian
Director of Library Technology
Rec
eive
pho
togr
aphs
Evaluate embedded metadata; determine DC mappings & fields to be added
Identify new keywords to be mapped; update keyword mapping table
Run scripts, output DC metadata as CSV file
Review & approve metadata
Inge
st C
SV
and
pho
to fi
les;
pu
blis
h to
dis
cove
ry la
yer
Write shell scripts to transform & map embedded metadata
Write shell scripts to extract keywords & other metadata created by photographer
![Page 9: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/9.jpg)
Overview of the Libraries’ Workflow Subsequent Loads
Metadata Librarian
Director of Library Technology
Rec
eive
pho
togr
aphs
Extract keywords
Identify new keywords to be mapped; update keyword mapping table
Run scripts, output DC metadata as CSV file
Review & approve metadata
Inge
st C
SV
and
pho
to fi
les,
pu
blis
h to
dis
cove
ry la
yer
![Page 10: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/10.jpg)
Extracting, Evaluating and Transforming Metadata
![Page 11: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/11.jpg)
Extracting, Evaluating and Transforming Metadata
![Page 12: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/12.jpg)
Keywords à Subject Headings
![Page 13: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/13.jpg)
Keywords à Subject Headings
![Page 14: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/14.jpg)
Keywords à Subject Headings Events (dcterms:TGM) Class reunions--New York (State)--Binghamton (dcterms:LCSH) State University of New York at Binghamton--Alumni and alumnae (dcterms:LCSH) Events Center (dcterms:spatial) Fine Arts Building (dcterms:spatial) Fine Arts Building. Memorial Courtyard (dcterms:spatial) State University of New York at Binghamton--Buildings(dcterms:LCSH) State University of New York at Binghamton--Students (dcterms:LCSH)
![Page 15: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/15.jpg)
Keywords à Subject Headings Events (dcterms:TGM) Class reunions--New York (State)--Binghamton (dcterms:LCSH) State University of New York at Binghamton--Alumni and alumnae (dcterms:LCSH) Events Center (dcterms:spatial) Fine Arts Building (dcterms:spatial) Fine Arts Building. Memorial Courtyard (dcterms:spatial) State University of New York at Binghamton--Buildings(dcterms:LCSH) State University of New York at Binghamton--Students (dcterms:LCSH)
![Page 16: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/16.jpg)
Keywords à Subject Headings
![Page 17: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/17.jpg)
Technical Details: Shell Scripts
Key tools: • exiftool
• awk • sed • echo
# Extract all appropriate Metadata for all files and write to $TEMPFILE exiftool -T -filename -FileType -Format -DateCreated –ImageSize / -XMP-dc:Creator -XMP-dc:Description -XMP-dc:Subject / $IMAGES >> $TEMPDIR"/"$TEMPFILE
![Page 18: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/18.jpg)
Making a Deposit
![Page 19: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/19.jpg)
Making a Deposit
CSV + images files à preservation system
![Page 20: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/20.jpg)
Metadata Display
![Page 21: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/21.jpg)
Metadata Display
![Page 22: Transforming and enhancing metadata for enduser discovery ...eprints.rclis.org/22705/1/Presentation_corrado_jaffe.pdf · a case study Edward M. Corrado Director of Library Technology](https://reader033.vdocuments.us/reader033/viewer/2022051921/600e2e4b3886d0231f0dcdf3/html5/thumbnails/22.jpg)
Questions?
• Contact: [email protected] [email protected]
• Special thanks to: Jonathan Cohen University Photographer Binghamton University