System File Type

gif

Image

Overview

A Graphics Interchange Format raster image.

Characteristics

Palette-based lossless image format supporting transparency and multiple frames for simple animation.

Common Uses

Small web graphics, icons, short looping animations, and compatibility-focused image exchange.

Compatible Programs

Windows Photos
Adobe Photoshop
GIMP
IrfanView

Sources

gif Available by Year Taken/Created

gif — Live from Microsoft

Secure, read-only view focused directly on the gif file-type folder.

Camera Fields

These 75 columns in [AUROS].[DZFILESYSFILES].[FILETYPE GIF] preserve camera, device, lens, source, software, capture, location, and format-specific metadata embedded in GIF files. Values are copied from the file; they are not inferred.

GIF metadata: GIF has no standardized EXIF camera block. Device information is available only when retained in optional XMP, comments, or application-extension metadata. A NULL value means the source file did not contain a readable value for that field.

Device Identity

SQL column	What it records
`Camera - Make`	Manufacturer recorded for the capture device.
`Camera - Model`	Model recorded for the capture device.
`Camera - Unique Model`	Globally unique camera-model name, primarily used by DNG.
`Camera - Localized Model`	Localized display name for the camera model.
`Camera - Serial Number`	Camera or device serial number.
`Camera - Owner Name`	Owner name written by the camera.
`Camera - Body Serial Number`	Serial number of the camera body.
`Camera - Internal Serial Number`	Manufacturer-specific internal camera serial number.
`Camera - Sensor Serial Number`	Manufacturer-specific image-sensor serial number.
`Camera - ID`	Manufacturer-specific camera identifier.
`Camera - Type`	Manufacturer-specific camera or device type.
`Camera - Firmware Version`	Firmware version recorded by the device.
`Camera - Shutter Count`	Camera shutter or image-actuation count when recorded.
`Camera - Maker Note`	Manufacturer-specific EXIF MakerNote payload or its recorded presence.

Lens

SQL column	What it records
`Camera - Lens - Specification`	Minimum/maximum focal length and aperture specification.
`Camera - Lens - Make`	Lens manufacturer.
`Camera - Lens - Model`	Lens model.
`Camera - Lens - Serial Number`	Lens serial number.
`Camera - Lens - Type`	Manufacturer-specific lens type.
`Camera - Lens - ID`	Manufacturer-specific lens identifier.

Source

SQL column	What it records
`Camera - Source - File Source`	EXIF source type, such as digital still camera.
`Camera - Source - Scene Type`	Whether the image was directly photographed.
`Camera - Source - Sensing Method`	Type and arrangement of the image sensor.
`Camera - Source - Device Setting Description`	Device configuration recorded for the capture.
`Camera - Source - Digital Source Type`	XMP/IPTC classification of camera, scan, composite, or generated source.
`Camera - Source - Composite Image`	Whether the image is a composite of multiple captures.
`Camera - Source - Composite Source Image Count`	Number of source images in a composite.
`Camera - Source - Composite Source Exposure Times`	Exposure times of images used in a composite.

Software

SQL column	What it records
`Camera - Software - Name`	Software recorded as writing or processing the image.
`Camera - Software - Processing Software`	Processing software recorded in TIFF/EXIF metadata.
`Camera - Software - Host Computer`	Computer recorded as writing or processing the image.
`Camera - Software - Creator Tool`	XMP tool that created or last authored the image.
`Camera - Software - History Software Agent`	Software agents recorded in XMP edit history.

Capture

SQL column	What it records
`Camera - Capture - Date Time Original`	Original capture date and time.
`Camera - Capture - Offset Time Original`	Time-zone offset for the original capture time.
`Camera - Capture - Subsecond Time Original`	Subsecond component of the original capture time.
`Camera - Capture - Exposure Time`	Exposure duration.
`Camera - Capture - Shutter Speed`	APEX or calculated shutter speed.
`Camera - Capture - F Number`	Lens f-number used for the exposure.
`Camera - Capture - Aperture`	APEX or calculated aperture value.
`Camera - Capture - ISO`	ISO or photographic sensitivity.
`Camera - Capture - Sensitivity Type`	EXIF interpretation of recorded sensitivity values.
`Camera - Capture - Standard Output Sensitivity`	Standard output sensitivity reported by the device.
`Camera - Capture - Recommended Exposure Index`	Recommended exposure index reported by the device.
`Camera - Capture - Exposure Program`	Automatic or manual exposure program.
`Camera - Capture - Exposure Mode`	Automatic, manual, or bracketed exposure mode.
`Camera - Capture - Metering Mode`	Camera light-metering mode.
`Camera - Capture - Light Source`	Recorded light source or illumination type.
`Camera - Capture - Flash`	Flash status and mode.
`Camera - Capture - Focal Length`	Lens focal length used for the capture.
`Camera - Capture - Focal Length 35mm`	35mm-equivalent focal length.
`Camera - Capture - Digital Zoom Ratio`	Digital zoom ratio.
`Camera - Capture - Subject Distance`	Recorded subject distance.
`Camera - Capture - White Balance`	Automatic or manual white-balance mode.
`Camera - Capture - Scene Capture Type`	Standard, landscape, portrait, night, or another scene mode.
`Camera - Capture - Gain Control`	Camera gain adjustment.
`Camera - Capture - Contrast`	Camera contrast-processing setting.
`Camera - Capture - Saturation`	Camera saturation-processing setting.
`Camera - Capture - Sharpness`	Camera sharpness-processing setting.
`Camera - Capture - Subject Distance Range`	Macro, close, or distant subject range.
`Camera - Capture - Orientation`	Recorded sensor/image orientation.

GPS and Location

SQL column	What it records
`Camera - GPS - Latitude`	Capture latitude.
`Camera - GPS - Longitude`	Capture longitude.
`Camera - GPS - Altitude`	Capture altitude.
`Camera - GPS - Time Stamp`	GPS capture time.
`Camera - GPS - Date Stamp`	GPS capture date.

Color Profile

SQL column	What it records
`Camera - Color Profile - Class`	ICC profile class, such as input, display, or output device.
`Camera - Color Profile - Device Manufacturer`	Manufacturer identifier in the embedded ICC profile.
`Camera - Color Profile - Device Model`	Device-model identifier in the embedded ICC profile.
`Camera - Color Profile - Device Attributes`	ICC device attributes.
`Camera - Color Profile - Device Technology`	ICC device-technology classification.
`Camera - Color Profile - Description`	Human-readable embedded color-profile description.

GIF

SQL column	What it records
`Camera - GIF - Application Identifier`	GIF Application Extension identifier.
`Camera - GIF - Application Authentication Code`	GIF Application Extension authentication code.
`Camera - GIF - Comment`	GIF comment metadata, which may name the creating software.

Location Fields

These 40 columns in [AUROS].[DZFILESYSFILES].[FILETYPE GIF] preserve location metadata embedded in GIF files. Values are copied from the file and are not inferred from its folder or filename.

GIF location metadata: GIF has no native geographic schema. Location information can exist in a Comment Extension or in XMP carried by an Application Extension. A NULL value means the source file did not contain a readable value for that field.

GIF

SQL column	What it records
`Location - GIF - Comment`	GIF Comment Extension text that may describe a location.
`Location - GIF - Application Identifier`	Identifier of a GIF Application Extension carrying location metadata.
`Location - GIF - Application Data`	Application Extension data carrying location metadata, such as an XMP packet.

XMP GPS

SQL column	What it records
`Location - XMP GPS - Latitude`	Latitude recorded for the image.
`Location - XMP GPS - Longitude`	Longitude recorded for the image.
`Location - XMP GPS - Altitude`	Altitude recorded for the image.
`Location - XMP GPS - Altitude Reference`	Whether altitude is above or below the reference level.

IPTC Legacy

SQL column	What it records
`Location - IPTC Legacy - Sublocation`	Legacy IPTC location or sublocation shown in the image.
`Location - IPTC Legacy - City`	Legacy IPTC city shown in the image.
`Location - IPTC Legacy - Province or State`	Legacy IPTC province or state shown in the image.
`Location - IPTC Legacy - Country Name`	Legacy IPTC country name shown in the image.
`Location - IPTC Legacy - Country Code`	Legacy IPTC ISO country code shown in the image.

Created

SQL column	What it records
`Location - Created - Structure`	Complete IPTC structured location describing where the image was created.
`Location - Created - City`	City of the location. This structure describes where the image was created.
`Location - Created - Country Code`	ISO country code of the location. This structure describes where the image was created.
`Location - Created - Country Name`	Country name of the location. This structure describes where the image was created.
`Location - Created - GPS Altitude`	Altitude of the location. This structure describes where the image was created.
`Location - Created - GPS Altitude Reference`	Reference indicating whether the altitude is above or below WGS84. This structure describes where the image was created.
`Location - Created - GPS Latitude`	Latitude of the location. This structure describes where the image was created.
`Location - Created - GPS Longitude`	Longitude of the location. This structure describes where the image was created.
`Location - Created - Identifier`	Identifier recorded for the location structure. This structure describes where the image was created.
`Location - Created - Location ID`	Globally unique identifier for the location. This structure describes where the image was created.
`Location - Created - Location Name`	Full human-readable name of the location. This structure describes where the image was created.
`Location - Created - Province or State`	Province or state of the location. This structure describes where the image was created.
`Location - Created - Sublocation`	Sublocation or named site within the location. This structure describes where the image was created.
`Location - Created - World Region`	World region containing the location. This structure describes where the image was created.

Shown

SQL column	What it records
`Location - Shown - Structure`	Complete IPTC structured location describing a place depicted in the image.
`Location - Shown - City`	City of the location. This structure describes a place depicted in the image.
`Location - Shown - Country Code`	ISO country code of the location. This structure describes a place depicted in the image.
`Location - Shown - Country Name`	Country name of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Altitude`	Altitude of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Altitude Reference`	Reference indicating whether the altitude is above or below WGS84. This structure describes a place depicted in the image.
`Location - Shown - GPS Latitude`	Latitude of the location. This structure describes a place depicted in the image.
`Location - Shown - GPS Longitude`	Longitude of the location. This structure describes a place depicted in the image.
`Location - Shown - Identifier`	Identifier recorded for the location structure. This structure describes a place depicted in the image.
`Location - Shown - Location ID`	Globally unique identifier for the location. This structure describes a place depicted in the image.
`Location - Shown - Location Name`	Full human-readable name of the location. This structure describes a place depicted in the image.
`Location - Shown - Province or State`	Province or state of the location. This structure describes a place depicted in the image.
`Location - Shown - Sublocation`	Sublocation or named site within the location. This structure describes a place depicted in the image.
`Location - Shown - World Region`	World region containing the location. This structure describes a place depicted in the image.

Time and Date Fields

These 36 columns in [AUROS].[DZFILESYSFILES].[FILETYPE GIF] preserve date, time, duration, time-code, and animation-timing values available in GIF files. Values are copied from the source file and are not inferred from its filename or folder.

GIF time and date metadata: GIF animation timing is stored as per-frame delays. GIF files may also carry XMP and ICC temporal metadata. A NULL value means the source file did not contain a readable value for that field.

File

SQL column	What it records
`Time - File - Access Date`	Filesystem date and time when the file was last accessed.
`Time - File - Create Date`	Filesystem date and time when the file was created.
`Time - File - Inode Change Date`	Filesystem date and time when the file record or metadata last changed, when the filesystem exposes it.
`Time - File - Modify Date`	Filesystem date and time when the file content was last modified.

GIF

SQL column	What it records
`Time - GIF - Frame Delay`	Delay assigned to a GIF animation frame, in hundredths of a second.
`Time - GIF - Duration`	Total duration of the GIF animation.

XMP Core

SQL column	What it records
`Time - XMP Core - Create Date`	XMP date and time when the resource was created.
`Time - XMP Core - Modify Date`	XMP date and time when the resource was last modified.
`Time - XMP Core - Metadata Date`	XMP date and time when the metadata was last changed.

XMP EXIF

SQL column	What it records
`Time - XMP EXIF - Date Time Original`	XMP EXIF date and time when the original image was captured.
`Time - XMP EXIF - Date Time Digitized`	XMP EXIF date and time when the image was digitized.
`Time - XMP EXIF - GPS Date Time`	Combined UTC GPS date and time stored in XMP EXIF metadata.

XMP Photoshop

SQL column	What it records
`Time - XMP Photoshop - Date Created`	XMP Photoshop date and time when the intellectual content was created.

XMP Dublin Core

SQL column	What it records
`Time - XMP Dublin Core - Date`	Dublin Core date or dates associated with the resource.

XMP IPTC

SQL column	What it records
`Time - XMP IPTC - Time Created`	IPTC Core time associated with creation of the image content.
`Time - XMP IPTC - IPTC Last Edited`	Date and time when IPTC metadata was last edited.
`Time - XMP IPTC - Metadata Last Edited`	Date and time when the extended IPTC metadata was last edited.
`Time - XMP IPTC - Metadata Modification Date`	Date and time when the metadata record was modified.
`Time - XMP IPTC - Modification Date`	Modification date and time stored in IPTC Extension metadata.
`Time - XMP IPTC - Original Create Date Time`	Original creation date and time recorded in IPTC Extension metadata.
`Time - XMP IPTC - Publication Event Date`	Date or dates associated with a publication event.
`Time - XMP IPTC - Temporal Coverage From`	Beginning of the time period covered by the image.
`Time - XMP IPTC - Temporal Coverage To`	End of the time period covered by the image.

XMP History

SQL column	What it records
`Time - XMP History - History When`	Date and time of each recorded XMP history event.
`Time - XMP History - Versions Event When`	Date and time of a version event.
`Time - XMP History - Versions Modify Date`	Modification date and time recorded for a version.

XMP Lineage

SQL column	What it records
`Time - XMP Lineage - Derived From Last Modify Date`	Last modification date of the source from which this image was derived.
`Time - XMP Lineage - Ingredients Last Modify Date`	Last modification date of an ingredient used to create the image.
`Time - XMP Lineage - Managed From Last Modify Date`	Last modification date of the managed source resource.
`Time - XMP Lineage - Manifest Reference Last Modify Date`	Last modification date of a resource referenced by a manifest.
`Time - XMP Lineage - Rendition Of Last Modify Date`	Last modification date of the resource of which this is a rendition.

XMP Rights

SQL column	What it records
`Time - XMP Rights - License Start Date`	Beginning of the licensed-use period.
`Time - XMP Rights - License End Date`	End of the licensed-use period.
`Time - XMP Rights - License Transaction Date`	Date and time of the licensing transaction.

ICC

SQL column	What it records
`Time - ICC - Profile Date Time`	Date and time when the embedded ICC color profile was created.
`Time - ICC - Calibration Date Time`	Date and time of the calibration described by the embedded color profile.

System File Type – gif