revised: 05-Feb-2015

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

In the interests of standardization and interoperability, we are migrating our geologic maps into the USGS NCGMP09 data model. However, our well data model is still actively being used. Documentation for the NMBGMR geology data model is being provided for users with legacy data in this model. We also hope that it will provoke discussion in the ongoing effort to improve NCGMP09 and other models.

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.