NMBGMR Draft Geologic Data Model - v. 1.0.3
JOINED & RELATED TABLES

revised: 29-Feb-2012

Table Name: Images

This table is a means of storing both images and image attributes within a geodatabase. The location of the image could either be in Data_point or Feature_point (or both). Image attributes can also be stored within the EXIF header of images. However, a means of querying that data within the geodatabase would be needed.

Field Name Field Alias Length
(text fields)
Field Type Field Value Default Allow Nulls? Attributes / Examples Description / Notes
PhotoID " 50 String variable undefined TRUE [null], frame 25 linked to Data_point or Feature_point
StationID " 50 String variable [null] TRUE ID of station location Station ID (if specified)
Feature_ID " 50 String variable [null] TRUE ID of subject of image Could be basis of link to Feature_point
ImageDate " 12 date variable [null] TRUE date image was taken Date image was taken
ImageFile "   raster raster [null] TRUE [raster file] Raster image field type is only supported by geodatabases
SourceID " 128 String variable [null]   unknown; unspecified; Smith, 2006b [variable] Feature level metadata (who mapped this); related to bibliographic detail
Comments " 255 String variable [null] TRUE   Comments about this image.