Table A-14. Data dictionary for the BIOSLIDE table (tblBioSlide)

The BioSlide Table is a list of digital still images with only non-zero UnitRecID fields. These images are the most pertinent to the mapping data house in the database. The same UnitRecID may be used for multiple photos. However, each photo may have only one unit with which it is associated. In this table, the UnitRecID field will not be “0.”



Field Name

Type

Description

SlideID

N

A unique numeric ID assigned to each slide or photo

UnitRecID

N

Automatically-generated number field; the database primary key required for relationships between tables

SlideName

T50

A unique alphanumeric name assigned to each slide or photo

ImageName

T75

Full image name with .jpg extension (required to enable PhotoLink)

TapeTime

D/T

Exact time during aerial video imaging (AVI) survey when digital image was collected; used to link photo to digital trackline and position

SlideDescription

T255

Text field for biological comments regarding the digital photo or slide

Good Example?

Y/N

When set to Y: photo is representative of a particular biological feature or classification type

ImageType

T10

Media type of original image: Digital or Slide

FolderName

T50

Name of the folder in which digital images are stored (required to enable PhotoLink)

PhotoLink

Hyperlink

Enables linkage to photos placed in directories near the database

PHY Good Example?

Y/N

When set to Y: photo is geomorphological representative of a particular feature or classification type

PHY SlideComment

T255

Text field for geomorphological comments regarding the digital photo or slide