System File Type
jfif
Image
Overview
A JPEG-family photographic raster image.
Characteristics
Usually uses lossy discrete-cosine compression with adjustable quality; JFIF is a common interchange wrapper for JPEG-coded images.
Common Uses
Digital photographs, web images, email attachments, scans, and camera output.
Compatible Programs
- Windows Photos
- Adobe Photoshop
- GIMP
- IrfanView
Sources
jfif Available by Year Taken/Created
jfif — Live from Microsoft
Secure, read-only view focused directly on the jfif file-type folder.
Camera Fields
These 78 columns in [AUROS].[DZFILESYSFILES].[FILETYPE JFIF] preserve camera, device, lens, source, software, capture, location, and format-specific metadata embedded in JFIF files. Values are copied from the file; they are not inferred.
JFIF metadata: JFIF header fields describe JPEG density and thumbnails. Camera identity and capture information, when present, comes from additional EXIF, XMP, or MakerNote segments. 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. |
JFIF Header
| SQL column | What it records |
|---|---|
Camera - JFIF - Version | JFIF header version. |
Camera - JFIF - Resolution Unit | Unit used for JFIF pixel density. |
Camera - JFIF - X Resolution | Horizontal JFIF pixel density. |
Camera - JFIF - Y Resolution | Vertical JFIF pixel density. |
Camera - JFIF - Thumbnail Width | Width of the JFIF thumbnail. |
Camera - JFIF - Thumbnail Height | Height of the JFIF thumbnail. |
Location Fields
These 65 columns in [AUROS].[DZFILESYSFILES].[FILETYPE JFIF] preserve location metadata embedded in JFIF files. Values are copied from the file and are not inferred from its folder or filename.
JFIF location metadata: The JFIF APP0 header has no location fields. A JFIF-labelled JPEG stream can still carry EXIF, XMP, and IPTC location metadata in additional application segments. A NULL value means the source file did not contain a readable value for that field.
GPS
| SQL column | What it records |
|---|---|
Location - GPS - Version ID | Version of the EXIF GPS information block. |
Location - GPS - Latitude Reference | North or south latitude reference. |
Location - GPS - Latitude | Latitude recorded for the image. |
Location - GPS - Longitude Reference | East or west longitude reference. |
Location - GPS - Longitude | Longitude recorded for the image. |
Location - GPS - Altitude Reference | Whether altitude is above or below the reference level. |
Location - GPS - Altitude | Altitude recorded for the image. |
Location - GPS - Time Stamp | UTC time reported by the GPS receiver. |
Location - GPS - Satellites | GPS satellites used for the measurement. |
Location - GPS - Status | Status of the GPS receiver measurement. |
Location - GPS - Measure Mode | Two-dimensional or three-dimensional GPS measurement mode. |
Location - GPS - DOP | GPS dilution of precision. |
Location - GPS - Speed Reference | Unit used for GPS speed. |
Location - GPS - Speed | Speed recorded by the GPS receiver. |
Location - GPS - Track Reference | True or magnetic reference for movement direction. |
Location - GPS - Track | Direction of movement recorded by GPS. |
Location - GPS - Image Direction Reference | True or magnetic reference for camera direction. |
Location - GPS - Image Direction | Direction in which the camera was pointing. |
Location - GPS - Map Datum | Geodetic survey datum used for the coordinates. |
Location - GPS - Destination Latitude Reference | North or south reference for destination latitude. |
Location - GPS - Destination Latitude | Latitude of the recorded destination. |
Location - GPS - Destination Longitude Reference | East or west reference for destination longitude. |
Location - GPS - Destination Longitude | Longitude of the recorded destination. |
Location - GPS - Destination Bearing Reference | True or magnetic reference for destination bearing. |
Location - GPS - Destination Bearing | Bearing to the recorded destination. |
Location - GPS - Destination Distance Reference | Unit used for destination distance. |
Location - GPS - Destination Distance | Distance to the recorded destination. |
Location - GPS - Processing Method | Method used to determine the GPS position. |
Location - GPS - Area Information | Name or description of the GPS area. |
Location - GPS - Date Stamp | UTC date reported by the GPS receiver. |
Location - GPS - Differential | Whether differential GPS correction was applied. |
Location - GPS - Horizontal Positioning Error | Estimated horizontal positioning error. |
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 66 columns in [AUROS].[DZFILESYSFILES].[FILETYPE JFIF] preserve date, time, duration, time-code, and animation-timing values available in JFIF files. Values are copied from the source file and are not inferred from its filename or folder.
JFIF time and date metadata: The JFIF header has no date field, but a JFIF-labelled JPEG stream can carry EXIF, IPTC, XMP, ICC, and composite date/time metadata in other segments. 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. |
EXIF
| SQL column | What it records |
|---|---|
Time - EXIF - Modify Date | EXIF date and time when the image metadata or image was modified. |
Time - EXIF - Date Time Original | EXIF date and time when the original image data was generated. |
Time - EXIF - Create Date | EXIF date and time when the digital image data was created. |
Time - EXIF - Offset Time | UTC offset associated with EXIF Modify Date. |
Time - EXIF - Offset Time Original | UTC offset associated with EXIF Date Time Original. |
Time - EXIF - Offset Time Digitized | UTC offset associated with EXIF Create Date. |
Time - EXIF - Sub Second Time | Fractional seconds associated with EXIF Modify Date. |
Time - EXIF - Sub Second Time Original | Fractional seconds associated with EXIF Date Time Original. |
Time - EXIF - Sub Second Time Digitized | Fractional seconds associated with EXIF Create Date. |
Time - EXIF - GPS Date Stamp | UTC calendar date reported by the GPS receiver. |
Time - EXIF - GPS Time Stamp | UTC time of day reported by the GPS receiver. |
Time - EXIF - Preview Date Time | Date and time stored for an embedded preview image. |
Time - EXIF - Thumbnail Date Time | Date and time stored for an embedded thumbnail image. |
Time - EXIF - Time Zone Offset | Legacy EXIF time-zone offset associated with image timestamps. |
Time - EXIF - Exposure Time | Length of time the camera sensor was exposed. |
IPTC Legacy
| SQL column | What it records |
|---|---|
Time - IPTC Legacy - Date Created | Legacy IPTC calendar date when the intellectual content was created. |
Time - IPTC Legacy - Time Created | Legacy IPTC time when the intellectual content was created. |
Time - IPTC Legacy - Digital Creation Date | Legacy IPTC calendar date when the digital representation was created. |
Time - IPTC Legacy - Digital Creation Time | Legacy IPTC time when the digital representation was created. |
Time - IPTC Legacy - Release Date | Legacy IPTC date on or after which the image may be released. |
Time - IPTC Legacy - Release Time | Legacy IPTC time on or after which the image may be released. |
Time - IPTC Legacy - Expiration Date | Legacy IPTC date after which the image should not be used. |
Time - IPTC Legacy - Expiration Time | Legacy IPTC time after which the image should not be used. |
Time - IPTC Legacy - Date Sent | Legacy IPTC date when the image was sent. |
Time - IPTC Legacy - Time Sent | Legacy IPTC time when the image was sent. |
Time - IPTC Legacy - Reference Date | Legacy IPTC reference date associated with the image. |
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. |
Composite
| SQL column | What it records |
|---|---|
Time - Composite - Sub Second Create Date | Composite EXIF Create Date including fractional seconds and UTC offset when available. |
Time - Composite - Sub Second Date Time Original | Composite original-capture date including fractional seconds and UTC offset when available. |
Time - Composite - Sub Second Modify Date | Composite EXIF Modify Date including fractional seconds and UTC offset when available. |
Time - Composite - Date Time Created | Composite IPTC date and time when the image content was created. |
Time - Composite - Digital Creation Date Time | Composite IPTC date and time when the digital image was created. |
Time - Composite - GPS Date Time | Composite UTC date and time calculated from GPS date and time fields. |