Air Photo Index & Metadata from Master Spreadsheet

Outline

These Python scripts allow the transform a Master Spreadsheet into an geographic index of entries and create metadata from the entries. In addition this set includes scripts for creating thumbnails from images (air photos in our case), and compressing files (xml and tif for us) in folders up to a given size.

Air Photo Index

The Air Photo Index is an open source Leaflet webmap, with markers that display information for different entries, and a time slider to move through different years. Other features include zooming, drag navigation, scale, and ability to change the base map. This is done by pulling information from the Master Spreadsheet.

Metadata

The Python script generates formatted and tab-delimited metadata in a .txt file from the Master Spreadsheet.

Other Scripts

Thumbnail and compression scripts were part of our work flow from ingesting information and images into the open-source islandora system used for the McMaster University Library Digital Archive.

Thumbnails

The thumbnail script requires the installation of ImageMagick in order to operate the script that converts your file into a JPEG with 200px width.

Compression

This script copies .tif and .xml files into folders up to sizes no greater than 2.14e9 bytes (approximately 2GB), and then compresses each folder. This is because islandora cannot batch upload files greater than 2GB in size.

More Information

Additional information can be found on our Working Instructions Page. Any additional information can be acquired by contacting this account.