View Source

*Title*

University Photographs with embedded metadata


*Description*
The collection consists of \~45,000 TIFF images with embedded descriptive metadata. The metadata is consistent, but is (mostly) just a list of keywords. These keywords need to be mapped to the proper Dublin Core metadata fields and, in many cases, the keywords needs to be mapped to different values, like a last name, to a full name, or a 2 letter building code, to the full building name. For example, “ec” needs to be mapped to “Events Center”

*Licensing*
_These photos are all rights reserved and can be used only for this mashup. A set of photos with the same or similar embedded metadata will be provided at a latter time.._

*Owner*
_Binghamton University._

*Dataset Location*
_It is on a USB key._ _Link to current shell script (complete with typos in the comments):_ [http://codabox.org/113/|http://codabox.org/113/]

*Dataset Champion*
[~ecorrado]


*Issues brainstorm*

* The first thing that needs to be done is extracting the metadata
* Currently a shell script calls exiftool and a bunch of sed  commands is being called to extract and manipulate the embeded metadata into Dublin Core-(like) metadata
* A configuration file of some sort that can be edited by a cataloging librarian (and not someone who knows sed, would be much more maintainable and extensible.3 things are needed: 1) the keyword embeded in the metdatadata, 2) What the keyword should become, and 3) What dublin core metadata field it should go into.

*List of Issues*

* Current method is not sustainable
* Need something a non-programer / non-system admin can edit that will create the mappings (see above)

*Sample exiftool output:*

[email protected]:~/exlibris/rosetta/university_photo/cumulus$ exiftool \-X \-IPTC:DateCreated \-XMP-dc:Description \-XMP-dc:Creator \-XMP-dc:Subject \-XMP-dc:Format \-System:Filename \*.tif
 


{code}
<?xml version='1.0' encoding='UTF-8'?>
<rdf:RDF xmlns:rdf='http://www.w3.org/1999/02/22-rdf-syntax-ns#'>

<rdf:Description rdf:about='20110522_commencement257_jwc.tif'
xmlns:et='http://ns.exiftool.ca/1.0/' et:toolkit='Image::ExifTool 8.60'
xmlns:IPTC='http://ns.exiftool.ca/IPTC/IPTC/1.0/'
xmlns:XMP-dc='http://ns.exiftool.ca/XMP/XMP-dc/1.0/'
xmlns:System='http://ns.exiftool.ca/File/System/1.0/'>
<IPTC:DateCreated>2011:05:22</IPTC:DateCreated>
<XMP-dc:Description>JONATHAN COHEN/BINGHAMTON UNIVERSITY
Binghamton University Harpur College 2011 Commencement afternoon ceremony held at the Events Center, Sunday, May 22, 2011.</XMP
-dc:Description>
<XMP-dc:Creator>JONATHAN COHEN</XMP-dc:Creator>
<XMP-dc:Subject>
<rdf:Bag>
<rdf:li>2011</rdf:li>
<rdf:li>events</rdf:li>
<rdf:li>on campus</rdf:li>
<rdf:li>commencement</rdf:li>
<rdf:li>events center</rdf:li>
<rdf:li>ec</rdf:li>
<rdf:li>harpur</rdf:li>
</rdf:Bag>
</XMP-dc:Subject>
<XMP-dc:Format>image/tiff</XMP-dc:Format>
<System:FileName>20110522_commencement257_jwc.tif</System:FileName>

</rdf:Description>

</rdf:RDF>
{code}Sample of what final metadata looks like after running script:

{code}
<?xml version="1.0" encoding="UTF-8"?>
<metadata xmlns="http://www.loc.gov/mods/v3" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1
.1/" xmlns:dcterms="http://purl.org/dc/terms/">
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Harpur College Ceremony held at the
 Events Center at Binghamton University Sunday, May 21, 2006.</dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement100_jwc.tif</dc:identifier>
</record>
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Professional Schools Ceremony held
at the Events Center at Binghamton University Sunday, May 21, 2006.  </dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement101_jwc.tif</dc:identifier>
</record>
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Harpur College Ceremony held at the
 Events Center at Binghamton University Sunday, May 21, 2006.</dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement102_jwc.tif</dc:identifier>
</record>
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Harpur College Ceremony held at the
 Events Center at Binghamton University Sunday, May 21, 2006.</dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement103_jwc.tif</dc:identifier>
</record>
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Harpur College Ceremony held at the
 Events Center at Binghamton University Sunday, May 21, 2006.</dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement104_jwc.tif</dc:identifier>
</record>
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Harpur College Ceremony held at the
 Events Center at Binghamton University Sunday, May 21, 2006.</dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement105_jwc.tif</dc:identifier>
</record>
<record>
   <dc:title>Harpur College 2006 Commencement</dc:title>
   <dcterms:isPartOf>Binghamton University Photography Collection</dcterms:isPartOf>
   <dcterms:isPartOf>Binghamton University Harpur College 2006 Commencement Photos</dcterms:isPartOf>
   <dcterms:issued>2006-05-21</dcterms:issued>>
   <dc:description>Binghamton University students receive their bachelor degrees during the Harpur College Ceremony held at the
 Events Center at Binghamton University Sunday, May 21, 2006.</dc:description>
   <dc:creator>Cohen, Jonathan</dc:creator>
   <dc:format>image/tiff</dc:format>
   <dc:identifier>20060521_commencement106_jwc.tif</dc:identifier>
</record>
</metadata>
{code}