Annotations from spreadsheet

This analysis module can annotate files in the dataset from a spreadsheet. Any format supported by the table service is accepted: Excel, CSV, HDF-5.

Requirements

  1. The spreadsheet with annotations must be a member of the dataset being annotated.
  2. One of the spreadsheet columns must contain a filename exactly as it appears on a resource name, with extension but without path.

Special system tags

  • 'file.name' - is used to find the resource to annotate, it is automatically set as a first column but can be changed with a drop down.

    • The system with try to match 'lat', 'long' and 'alt' in order to set resource's geo location. If matched the following tags will be added:

  • 'geo.latitude'
  • 'geo.longitude'
  • 'geo.altitude'

    • The system with try to match 'width', 'height' and 'units' in order to set resource's physical dimensions. Width and height tag names will be parsed in order to detect the resolution units, unless a column is provided. If matched and found the following tags will be added:

  • 'res.width'
  • 'res.height'
  • 'res.units'

    • Overwriting

    The default setting is to overwrite values of annotations already present on images. If you wish to simply append new annotations un-select the "overwrite annotations" checkbox.