Image Metadata Format Plugin

Introduced in release: 1.14

Drill can query the metadata in various image formats. The metadata format plugin is useful for querying a large number of image files stored in a distributed file system. You do not have to build a metadata repository in advance.

The metadata format plugin supports the following file formats:

JPEG, TIFF, PSD, PNG, BMP, GIF, ICO, PCX, WAV, AVI, WebP, MOV, MP4, EPS Camera Raw: ARW (Sony), CRW/CR2 (Canon), NEF (Nikon), ORF (Olympus), RAF (FujiFilm), RW2 (Panasonic), RWL (Leica), SRW (Samsung), X3F (Foveon)

The metadata format plugin enables Drill to read the following metadata:

Exif, IPTC, XMP, JFIF / JFXX, ICC Profiles, Photoshop fields, PNG properties, BMP properties, GIF properties, ICO properties, PCX properties, WAV properties, AVI properties, WebP properties, QuickTime properties, MP4 properties, EPS properties

Since each type of metadata has a different set of fields, the plugin returns a set of commonly-used fields, such as the image width, height, and bits per pixels for ease of use.

To configure Drill to read image metadata, you must modify the extensions section in the dfs storage plugin configuration, as shown:

"formats": {
 "image": {
   "type": "image",
   "extensions": [
     "jpg", "jpeg", "jpe", "tif", "tiff", "dng", "psd", "png", "bmp", "gif",
     "ico", "pcx", "wav", "wave", "avi", "webp", "mov", "mp4", "m4a", "m4p",
     "m4b", "m4r", "m4v", "3gp", "3g2", "eps", "epsf", "epsi", "ai", "arw",
     "crw", "cr2", "nef", "orf", "raf", "rw2", "rwl", "srw", "x3f"
   ]
   "fileSystemMetadata": true,
   "descriptive": true,
   "timeZone": null
 }
}

Note: The result does not include file names, but you can use implicit columns to get file names, full paths, fully qualified names, and file suffixes.

Attributes

The following table lists configuration attributes:

Attribute Default Value Description
fileSystemMetadata true Set to true to extract filesystem metadata including the file size and the last modified timestamp, false otherwise.
descriptive true Set to true to extract metadata in a human-readable string format. Set false to extract metadata in a machine-readable typed format.
timeZone null Specify the time zone to interpret the timestamp with no time zone information. If the timestamp includes the time zone information, this value is ignored. If null is set, the local time zone is used.

Examples

To follow along with the examples, start by downloading the following image to your \tmp directory.

image

A Drill query on a JPEG file with the property descriptive: true

select FileName, * from dfs.tmp.`7671b34d6e8a4d050f75278f10f1a08.jpg`;
    |-------------------------------------|-------------|---------------------------------|--------|------------|-------------|--------------|-------------|----------|-----------|-----------|----------|----------|------------|-----------|------------|-----------------|-----------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------|---------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|
    | FileName                            | FileSize    | FileDateTime                    | Format | PixelWidth | PixelHeight | BitsPerPixel | Orientaion  | DPIWidth | DPIHeight | ColorMode | HasAlpha | Duration | VideoCodec | FrameRate | AudioCodec | AudioSampleSize | AudioSampleRate | JPEG                                                                                                                                                                                                                                                                                                                                                                                          | JpegComment                                                                  | JFIF                                                                                                                                          | ExifIFD0                                                                  | GPS                                                                                                          | Huffman                               | FileType                                                                                                                                                        |
    |-------------------------------------|-------------|---------------------------------|--------|------------|-------------|--------------|-------------|----------|-----------|-----------|----------|----------|------------|-----------|------------|-----------------|-----------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------|---------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|
    | 7671b34d6e8a4d050f75278f10f1a08.jpg | 45877 bytes | Tue Mar 17 21:37:09 +02:00 2020 | JPEG   | 604        | 453         | 24           | Unknown (0) | 0        | 0         | RGB       | false    | 00:00:00 | Unknown    | 0         | Unknown    | 0               | 0               | {"CompressionType":"Baseline","DataPrecision":"8 bits","ImageHeight":"453 pixels","ImageWidth":"604 pixels","NumberOfComponents":"3","Component1":"Y component: Quantization table 0, Sampling factors 2 horiz/2 vert","Component2":"Cb component: Quantization table 1, Sampling factors 1 horiz/1 vert","Component3":"Cr component: Quantization table 1, Sampling factors 1 horiz/1 vert"} | {"JPEGComment":"CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 90\n"} | {"Version":"1.1","ResolutionUnits":"none","XResolution":"1 dot","YResolution":"1 dot","ThumbnailWidthPixels":"0","ThumbnailHeightPixels":"0"} | {"ResolutionUnit":"(No unit)","YCbCrPositioning":"Center of pixel array"} | {"GPSLatitudeRef":"N","GPSLatitude":"50° 27' 48.8\"","GPSLongitudeRef":"E","GPSLongitude":"30° 30' 31.21\""} | {"NumberOfTables":"4 Huffman tables"} | {"DetectedFileTypeName":"JPEG","DetectedFileTypeLongName":"Joint Photographic Experts Group","DetectedMIMEType":"image/jpeg","ExpectedFileNameExtension":"jpg"} |
    |-------------------------------------|-------------|---------------------------------|--------|------------|-------------|--------------|-------------|----------|-----------|-----------|----------|----------|------------|-----------|------------|-----------------|-----------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------|--------------------------------------------------------------------------------------------------------------|---------------------------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|

A Drill query on a JPEG file with the property descriptive: false

select FileName, * from dfs.tmp.`7671b34d6e8a4d050f75278f10f1a08.jpg`;
    |-------------------------------------|----------|-----------------------|--------|------------|-------------|--------------|------------|----------|-----------|-----------|----------|----------|------------|-----------|------------|-----------------|-----------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------|-------------------------------------------|----------------------------------------------------------------------------------------------------------------|----------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|
    | FileName                            | FileSize | FileDateTime          | Format | PixelWidth | PixelHeight | BitsPerPixel | Orientaion | DPIWidth | DPIHeight | ColorMode | HasAlpha | Duration | VideoCodec | FrameRate | AudioCodec | AudioSampleSize | AudioSampleRate | JPEG                                                                                                                                                                                                                                                                                                                                                                                                                                                       | JpegComment                                                                  | JFIF                                                                                                                   | ExifIFD0                                  | GPS                                                                                                            | Huffman              | FileType                                                                                                                                                        |
    |-------------------------------------|----------|-----------------------|--------|------------|-------------|--------------|------------|----------|-----------|-----------|----------|----------|------------|-----------|------------|-----------------|-----------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------|-------------------------------------------|----------------------------------------------------------------------------------------------------------------|----------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|
    | 7671b34d6e8a4d050f75278f10f1a08.jpg | 45877    | 2020-03-17 19:37:09.0 | JPEG   | 604        | 453         | 24           | 0          | 0.0      | 0.0       | RGB       | false    | 0        | Unknown    | 0.0       | Unknown    | 0               | 0.0             | {"CompressionType":0,"DataPrecision":8,"ImageHeight":453,"ImageWidth":604,"NumberOfComponents":3,"Component1":{"ComponentId":1,"HorizontalSamplingFactor":2,"VerticalSamplingFactor":2,"QuantizationTableNumber":0},"Component2":{"ComponentId":2,"HorizontalSamplingFactor":1,"VerticalSamplingFactor":1,"QuantizationTableNumber":1},"Component3":{"ComponentId":3,"HorizontalSamplingFactor":1,"VerticalSamplingFactor":1,"QuantizationTableNumber":1}} | {"JPEGComment":"CREATOR: gd-jpeg v1.0 (using IJG JPEG v62), quality = 90\n"} | {"Version":257,"ResolutionUnits":0,"XResolution":1,"YResolution":1,"ThumbnailWidthPixels":0,"ThumbnailHeightPixels":0} | {"ResolutionUnit":1,"YCbCrPositioning":1} | {"GPSLatitudeRef":"N","GPSLatitude":50.46355547157135,"GPSLongitudeRef":"E","GPSLongitude":30.508668422733077} | {"NumberOfTables":4} | {"DetectedFileTypeName":"JPEG","DetectedFileTypeLongName":"Joint Photographic Experts Group","DetectedMIMEType":"image/jpeg","ExpectedFileNameExtension":"jpg"} |
    |-------------------------------------|----------|-----------------------|--------|------------|-------------|--------------|------------|----------|-----------|-----------|----------|----------|------------|-----------|------------|-----------------|-----------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|------------------------------------------------------------------------------|------------------------------------------------------------------------------------------------------------------------|-------------------------------------------|----------------------------------------------------------------------------------------------------------------|----------------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------|

Retrieving GPS location data from the Exif metadata for the use of GIS functions.

select t.GPS.GPSLatitude as lat, t.GPS.GPSLongitude as lon from dfs.tmp.`7671b34d6e8a4d050f75278f10f1a08.jpg` t;
    |-------------------|--------------------|
    | lat               | lon                |
    |-------------------|--------------------|
    | 50.46355547157135 | 30.508668422733077 |
    |-------------------|--------------------|

Download all png images from Logos page and place them to /tmp/logos directory to examine the following example.

An example query to retrieve the images that are less than 640 x 480 pixels.

select FileName, PixelWidth, PixelHeight from dfs.tmp.`logos` where PixelWidth < 640 and PixelHeight < 480;
    |---------------------|------------|-------------|
    | FileName            | PixelWidth | PixelHeight |
    |---------------------|------------|-------------|
    | redbusLogo.png      | 500        | 325         |
    | option3-io-logo.png | 194        | 76          |
    | sanchezLogo.png     | 235        | 85          |
    | IORA_NUS.png        | 375        | 253         |
    |---------------------|------------|-------------|

Supported File Formats

Format File extension Description
JPEG jpg, jpeg, jpe, nef Joint Photographic Expert Group
TIFF tif, tiff, dng, nef, srw Tagged Image File Format
PSD psd Photoshop Document
PNG png Portable Network Graphics
BMP bmp Device Independent Bitmap
GIF gif Graphics Interchange Format
ICO ico Windows Icon
PCX pcx PiCture eXchange
WAV wav, wave Waveform Audio File Format
AVI avi Audio Video Interleaved
WebP webp WebP
MOV mov QuickTime Movie
MP4 mp4, m4a, m4p, m4b, m4r, m4v, 3gp, 3g2 MPEG-4 Part 14
EPS eps, epsf, epsi, ai Encapsulated PostScript
ARW arw, dng Sony Camera Raw
CRW crw Canon Camera Raw version 1
CR2 cr2 Canon Camera Raw version 2
ORF orf Olympus Camera Raw
RAF raf FujiFilm Camera Raw
RW2 rw2, rwl Panasonic Camera Raw

Supported Metadata

Metadata JPEG TIFF PSD PNG BMP GIF ICO PCX WAV AVI WebP MOV MP4 EPS ARW CRW CR2 ORF RAF RW2
FileType x x x x x x x x x x x x x x x x x x x x
JFIF x                                      
ExifIFD0 x x x                     x x   x x x x
ExifSubIFD x x x                     x x   x x x x
Interoperability x                           x   x   x x
GPS x x                         x   x      
PrintIM x                           x     x x x
ExifThumnail x x x                     x x   x   x x
XMP x x x x             x       x   x      
ICCProfile x x x x             x     x            
JPEG x                                   x x
IPTC x x x                     x            
Photoshop x x x                     x            
AdobeJPEG x                                      
Huffman x                                   x x
PSDHeader     x                                  
PNGIHDR       x                                
PNGPLTE       x                                
PNGTRNS       x                                
PNGChromaticities       x                                
PNGGAMA       x                                
PNGICCP       x                                
PNGSBIT       x                                
PNGSRGB       x                                
PNGTEXt       x                                
PNGZTXt       x                                
PNGITXt       x                                
PNGBKGD       x                                
PNGPHYs       x                                
PNGTIME       x                                
BMPHeader         x                              
GIFHeader           x                            
GIFControl           x                            
GIFAnimation           x                            
GIFImage           x                            
ICO             x                          
PCX               x                        
WAV                 x                      
AVI                   x                    
WebP                     x                  
QuickTime                       x                
QuickTimeVideo                       x                
QuickTimeSound                       x                
QuickTimeMetadata                       x                
MP4                         x              
MP4Video                         x              
MP4Sound                         x              
EPS                           x            
SonyMakernote x                           x          
CanonMakernote x                               x      
NikonMakernote x x                                    
OlympusMakernote x                                 x    
OlympusEquipment x                                 x    
OlympusCameraSettings x                                 x    
OlympusRawDevelopment x                                 x    
OlympusImageProcessing x                                 x    
OlympusFocusInfo x                                 x    
OlympusRawInfo                                   x    
FujifilmMakernote x                                   x  
PanasonicMakernote x                                     x
PanasonicRawExifIFD0                                       x
PanasonicRawDistortionInfo                                       x
PanasonicRawWbInfo2                                       x
AppleMakernote x                                      
CasioMakernote x                                      
KyoceraContaxMakernote x                                      
LeicaMakernote                             x          
PentaxMakernote x                                      
ReconyxHyperFireMakernote x                                      
Samsung Makernote x x                         x          
SanyoMakernote x                                      
SigmaMakernote x                                      

Columns

Column Name Data Type Description
FileSize BIGINT File size in bytes
FileDateTime TIMESTAMP File modification date and time
Format VARCHAR File format: JPEG, TIFF, PSD, PNG, BMP, GIF, ICO, PCX, RIFF, WAV, AVI, WebP, MOV, MP4, EPS, ARW, CRW, CR2, NEF, ORF, RAF, RW2 or UNKNOWN
DPIWidth DOUBLE Horizontal dot per inch
DPIHeight DOUBLE Vertical dot per inch
PixelWidth INTEGER Image width in pixels
PixelHeight INTEGER Image height in pixels
BitsPerPixel INTEGER Bits per pixel
Orientation INTEGER Orientation of the image:
1 (Horizontal / normal)
2 (Mirror horizontal)
3 (Rotate 180)
4 (Mirror vertical)
5 (Mirror horizontal and rotate 270 CW)
6 (Rotate 90 CW)
7 (Mirror horizontal and rotate 90 CW)
8 (Rotate 270 CW)
ColorMode VARCHAR Color mode: RGB, Lab, CMYK, Multichannel, Duotone, Grayscale, Bitmap or Indexed
HasAlpha BOOLEAN true if the image has an alpha channel
Duration BIGINT Duration in seconds
VideoCodec VARCHAR Video Codec
FrameRate DOUBLE Frames per second
AudioCodec VARCHAR Audio Codec
AudioSampleSize INTEGER Bits per sample
AudioSampleRate DOUBLE Samples per second
FileType.DetectedFileTypeName VARCHAR Detected file type: JPEG, TIFF, PSD, PNG, BMP, GIF, ICO, PCX, RIFF, WAV, AVI, WebP, MOV, MP4, EPS, ARW, CRW, CR2, NEF, ORF, RAF, RW2 or UNKNOWN
FileType.DetectedFileTypeLongName VARCHAR  
FileType.DetectedMIMEType VARCHAR MIME type: image/jpeg
FileType.ExpectedFileNameExtension VARCHAR Expected file extension: jpg
JFIF.Version INTEGER The second least significant byte is used for major revisions, and the least significant byte for minor revisions
JFIF.ResolutionUnits INTEGER Resolution unit: 0 (None), 2 (inches) or 3 (cm)
JFIF.XResolution INTEGER Horizontal pixel resolution
JFIF.YResolution INTEGER Vertical pixel resolution
JFIF.ThumbnailWidthPixels INTEGER Thumbnail horizontal pixel count
JFIF.ThumbnailHeightPixels INTEGER Thumbnail vertical pixel count
ExifIFD0.NewSubfileType INTEGER New subfile type:
0 (Full-resolution Image)
1 (Reduced-resolution image)
2 (Single page of multi-page image)
3 (Single page of multi-page reduced-resolution image)
4 (Transparency mask)
5 (Transparency mask of reduced-resolution image)
6 (Transparency mask of multi-page image)
7 (Transparency mask of reduced-resolution multi-page image)
ExifIFD0.ImageWidth INTEGER Number of columns of image data, equal to the number of pixels per row
ExifIFD0.ImageHeight INTEGER Number of rows of image data
ExifIFD0.BitsPerSample[3] INTEGER Number of bits per image component
ExifIFD0.Compression INTEGER Compression scheme used for the image data:
1 (Uncompressed)
2 (CCITT 1D)
3 (T4/Group 3 Fax)
4 (T6/Group 4 Fax)
5 (LZW)
6 (JPEG (old-style))
7 (JPEG)
8 (Adobe Deflate)
9 (JBIG B&W)
10 (JBIG Color)
99 (JPEG)
262 (Kodak 262)
32766 (Next)
32767 (Sony ARW Compressed)
32769 (Packed RAW)
32770 (Samsung SRW Compressed)
32771 (CCIRLEW)
32772 (Samsung SRW Compressed 2)
32773 (PackBits)
32809 (Thunderscan)
32867 (Kodak KDC Compressed)
32895 (IT8CTPAD)
32896 (IT8LW)
32897 (IT8MP
32898 (IT8BL)
32908 (PixarFilm)
32909 (PixarLog)
32946 (Deflate)
32947 (DCS)
34661 (JBIG)
34676 (SGILog)
34677 (SGILog24)
34712 (JPEG 2000)
34713 (Nikon NEF Compressed)
34715 (JBIG2 TIFF FX)
34718 (Microsoft Document Imaging (MDI) Binary Level Codec)
34719 (Microsoft Document Imaging (MDI) Progressive Transform Codec)
34720 (Microsoft Document Imaging (MDI) Vector)
34892 (Lossy JPEG)
65000 (Kodak DCR Compressed)
65535 (Pentax PEF Compressed)
ExifIFD0.PhotometricInterpretation INTEGER Color space of the image data components:
0 (WhiteIsZero)
1 (BlackIsZero)
2 (RGB)
3 (RGB Palette)
4 (Transparency Mask)
5 (CMYK)
6 (YCbCr)
8 (CIELab)
9 (ICCLab)
10 (ITULab)
32803 (Color Filter Array)
32844 (Pixar LogL)
32845 (Pixar LogLuv)
34892 (Linear Raw)
ExifIFD0.ImageDescription VARCHAR Title of the image
ExifIFD0.Make VARCHAR Manufacturer of the recording equipment
ExifIFD0.Model VARCHAR Model name of the recording equipment
ExifIFD0.StripOffsets INTEGER Position in the file of raster data
ExifIFD0.Orientation INTEGER Orientation of the image:
1 (Horizontal / normal)
2 (Mirror horizontal)
3 (Rotate 180)
4 (Mirror vertical)
5 (Mirror horizontal and rotate 270 CW)
6 (Rotate 90 CW)
7 (Mirror horizontal and rotate 90 CW)
8 (Rotate 270 CW)
ExifIFD0.SamplesPerPixel INTEGER Samples per pixel
ExifIFD0.RowsPerStrip INTEGER Raster is codified by a single block of data holding this many rows
ExifIFD0.StripByteCounts INTEGER Size of the raster data in bytes
ExifIFD0.XResolution DOUBLE Horizontal pixel resolution
ExifIFD0.YResolution DOUBLE Vertical pixel resolution
ExifIFD0.PlanarConfiguration INTEGER Indicates whether pixel components are recorded in chunky or planar format: 1 (Chunky) or 2 (Planar)
ExifIFD0.ResolutionUnit INTEGER Resolution unit: 1 (No unit), 2 (inches) or 3 (cm)
ExifIFD0.TransferFunction[768] INTEGER Transfer function for the image, described in tabular style
ExifIFD0.Software VARCHAR Name and version of the software used to generate the image
ExifIFD0.DateTime TIMESTAMP Date and time of image creation
ExifIFD0.Artist VARCHAR Person who created the image
ExifIFD0.Predictor INTEGER Mathematical operator that is applied to the image data before an encoding scheme is applied: 1 (None) or 2 (Horizontal differencing)
ExifIFD0.WhitePoint[2] DOUBLE Chromaticity of the white point of the image
ExifIFD0.PrimaryChromaticities[6] DOUBLE Chromaticity of the three primary colors of the image
ExifIFD0.YCbCrCoefficients[3] DOUBLE Matrix coefficients for transformation from RGB to YCbCr image data
ExifIFD0.YCbCrSubSampling[2] INTEGER Sampling ratio of chrominance components in relation to the luminance component
ExifIFD0.YCbCrPositioning INTEGER Positioning of subsampled chrominance components relative to luminance samples: 1 (Centered) or 2 (Co-sited)
ExifIFD0.ReferenceBlackWhite[6] DOUBLE Pair of headroom and footroom image data values (codes) for each pixel component. [blackR, blackG, blackB, whiteR, whiteG, whiteB]
ExifIFD0.Copyright VARCHAR Copyright notice
ExifIFD0.InterColorProfile VARBINARY ICC profile information
ExifSubIFD.ExposureTime DOUBLE Exposure time in seconds
ExifSubIFD.FNumber DOUBLE F Number
ExifSubIFD.ExposureProgram INTEGER Class of the program used by the camera to set exposure when the picture is taken:
1 (Manual control)
2 (Program normal)
3 (Aperture priority)
4 (Shutter priority)
5 (Program creative (slow program))
6 (Program action (high-speed program))
7 (Portrait mode)
8 (Landscape mode)
ExifSubIFD.SpectralSensitivity VARCHAR Spectral sensitivity of each channel of the camera used
ExifSubIFD.ISOSpeedRatings INTEGER ISO Speed
ExifSubIFD.OptoElectricConversionFunction(OECF) VARBINARY Opto-Electric Conversion Function (OECF) specified in ISO 14524
ExifSubIFD.SensitivityType INTEGER Indicates which one of the parameters of ISO12232 is the PhotographicSensitivity tag:
0 (Unknown)
1 (Standard Output Sensitivity)
2 (Recommended Exposure Index)
3 (ISO Speed)
4 (Standard Output Sensitivity and Recommended Exposure Index)
5 (Standard Output Sensitivity and ISO Speed)
6 (Recommended Exposure Index and ISO Speed)
7 (Standard Output Sensitivity, Recommended Exposure Index and ISO Speed)
ExifSubIFD.StandardOutputSensitivity INTEGER Standard output sensitivity value of a camera or input device defined in ISO 12232
ExifSubIFD.RecommendedExposureIndex INTEGER Recommended exposure index value of a camera or input device defined in ISO 12232
ExifSubIFD.ISOSpeed INTEGER ISO speed value of a camera or input device that is defined in ISO 12232
ExifSubIFD.ISOSpeedLatitudeYyy INTEGER ISO speed latitude yyy value of a camera or input device that is defined in ISO 12232
ExifSubIFD.ISOSpeedLatitudeZzz INTEGER ISO speed latitude zzz value of a camera or input device that is defined in ISO 12232
ExifSubIFD.ExifVersion VARCHAR The version is given as a string “0231” to indicate version 2.31
ExifSubIFD.DateTimeOriginal TIMESTAMP Date and time when the original image data was generated
ExifSubIFD.DateTimeDigitized TIMESTAMP Date and time when the image was stored as digital data
ExifSubIFD.OffsetTime VARCHAR Offset from UTC (the time difference from Universal Time Coordinated including daylight saving time) of the time of DateTime tag
ExifSubIFD.OffsetTimeOriginal VARCHAR Offset from UTC (the time difference from Universal Time Coordinated including daylight saving time) of the time of DateTimeOriginal tag
ExifSubIFD.OffsetTimeDigitized VARCHAR Offset from UTC (the time difference from Universal Time Coordinated including daylight saving time) of the time of DateTimeDigitized tag
ExifSubIFD.ComponentsConfiguration[4] INTEGER Channels of each component are arranged in order from the 1st component to the 4th (specific to compressed data)
ExifSubIFD.CompressedBitsPerPixel DOUBLE Compression mode used for a compressed image is indicated in unit bits per pixel
ExifSubIFD.ShutterSpeedValue DOUBLE Shutter speed. The unit is the APEX (Additive System of Photographic Exposure) setting
ExifSubIFD.ApertureValue DOUBLE Lens aperture. The unit is the APEX value
ExifSubIFD.BrightnessValue DOUBLE Brightness. The unit is the APEX value
ExifSubIFD.ExposureBiasValue DOUBLE Exposure bias. The units is the APEX value
ExifSubIFD.MaxApertureValue DOUBLE Smallest F number of the lens. The unit is the APEX value
ExifSubIFD.SubjectDistance DOUBLE Distance to the subject in meters
ExifSubIFD.MeteringMode INTEGER Metering mode:
0 (Unknown)
1 (Average)
2 (Center weighted average)
3 (Spot)
4 (Multi-spot)
5 (Multi-segment)
6 (Partial)
255 (Other)
ExifSubIFD.WhiteBalance INTEGER White balance:
0 (Unknown)
1 (Daylight)
2 (Florescent)
3 (Tungsten)
4 (Flash)
9 (Fine Weather)
10 (Cloudy)
11 (Shade)
12 (Daylight Fluorescent)
13 (Day White Fluorescent)
14 (Cool White Fluorescent)
15 (White Fluorescent)
16 (Warm White Fluorescent)
17 (Standard light)
18 (Standard light (B))
19 (Standard light (C))
20 (D55)
21 (D65)
22 (D75)
23 (D50)
24 (Studio Tungsten)
255 (Other)
ExifSubIFD.Flash INTEGER Flash mode:
0x0 (No Flash)
0x1 (Fired)
0x5 (Fired, Return not detected)
0x7 (Fired, Return detected)
0x8 (On, Did not fire)
0x9 (On, Fired)
0xd (On, Return not detected)
0xf (On, Return detected)
0x10 (Off, Did not fire)
0x14 (Off, Did not fire, Return not detected)
0x18 (Auto, Did not fire)
0x19 (Auto, Fired)
0x1d (Auto, Fired, Return not detected)
0x1f (Auto, Fired, Return detected)
0x20 (No flash function)
0x30 (Off, No flash function)
0x41 (Fired, Red-eye reduction)
0x45 (Fired, Red-eye reduction, Return not detected)
0x47 (Fired, Red-eye reduction, Return detected)
0x49 (On, Red-eye reduction)
0x4d (On, Red-eye reduction, Return not detected)
0x4f (On, Red-eye reduction, Return detected)
0x50 (Off, Red-eye reduction)
0x58 (Auto, Did not fire, Red-eye reduction)
0x59 (Auto, Fired, Red-eye reduction)
0x5d (Auto, Fired, Red-eye reduction, Return not detected)
0x5f (Auto, Fired, Red-eye reduction, Return detected)
ExifSubIFD.FocalLength DOUBLE Actual focal length of the lens in mm
ExifSubIFD.UserComment VARBINARY Keywords or comments on the image besides those in ImageDescription, and without the character code limitations of the ImageDescription tag
ExifSubIFD.SubSecTime VARCHAR Fractions of seconds for the DateTime tag
ExifSubIFD.SubSecTimeOriginal VARCHAR Fractions of seconds for the DateTimeOriginal tag
ExifSubIFD.SubSecTimeDigitized VARCHAR Fractions of seconds for the DateTimeDigitized tag
ExifSubIFD.Temperature DOUBLE Temperature as the ambient situation at the shot. The unit is °C
ExifSubIFD.Humidity DOUBLE Humidity as the ambient situation at the shot. The unit is %
ExifSubIFD.Pressure DOUBLE Pressure as the ambient situation at the shot. The unit is hPa
ExifSubIFD.WaterDepth DOUBLE Water depth as the ambient situation at the shot. The unit is m
ExifSubIFD.Acceleration DOUBLE Acceleration (a scalar regardless of direction) as the ambient situation at the shot. The unit is mGal (10-5 m/s2)
ExifSubIFD.CameraElevationAngle DOUBLE Elevation/depression angle of the orientation of the camera (imaging optical axis) as the ambient situation at the shot. The unit is degree(°)
ExifSubIFD.FlashPixVersion VARCHAR The version is given as a string “0100” to indicate version 1.0
ExifSubIFD.ColorSpace INTEGER Color space: 1 (sRGB) or 65535 (Undefined)
ExifSubIFD.ExifImageWidth INTEGER Valid width of the meaningful image (specific to compressed data)
ExifSubIFD.ExifImageHeight INTEGER Valid height of the meaningful image (specific to compressed data)
ExifSubIFD.RelatedSoundFile VARCHAR Name of an audio file related to the image data
ExifSubIFD.FlashEnergy DOUBLE Strobe energy at the time the image is captured, as measured in Beam Candle Power Seconds (BCPS)
ExifSubIFD.SpatialFrequencyResponse VARBINARY Camera or input device spatial frequency table and SFR values in the direction of image width, image height, and diagonal direction, as specified in ISO 12233
ExifSubIFD.FocalPlaneXResolution DOUBLE Number of pixels in the image width direction per FocalPlaneResolutionUnit on the camera focal plane
ExifSubIFD.FocalPlaneYResolution DOUBLE Number of pixels in the image height direction per FocalPlaneResolutionUnit on the camera focal plane
ExifSubIFD.FocalPlaneResolutionUnit INTEGER Unit for measuring FocalPlaneXResolution and FocalPlaneYResolution
ExifSubIFD.SubjectLocation[] INTEGER Location of the main subject in the scene
ExifSubIFD.ExposureIndex DOUBLE Exposure index selected on the camera or input device at the time the image is captured
ExifSubIFD.SensingMethod INTEGER Image sensor type:
1 (Not defined)
2 (One-chip color area sensor)
3 (Two-chip color area sensor)
4 (Three-chip color area sensor)
5 (Color sequential area sensor)
7 (Trilinear sensor)
8 (Color sequential linear sensor
ExifSubIFD.FileSource INTEGER Image source: 1 (Film Scanner), 2 (Reflection Print Scanner) or 3 (Digital Still Camera (DSC))
ExifSubIFD.SceneType INTEGER Type of scene: 1 (Directly photographed image)
ExifSubIFD.CFAPattern VARBINARY Color filter array (CFA) geometric pattern of the image sensor when a one-chip color area sensor is used
ExifSubIFD.CustomRendered INTEGER Special processing on image data, such as rendering geared to output: 0 (Normal process) or 1 (Custom process)
ExifSubIFD.ExposureMode INTEGER Exposure mode set when the image was shot: 0 (Auto exposure), 1(Manual exposure) or 2 (Auto bracket)
ExifSubIFD.WhiteBalanceMode INTEGER White balance mode set when the image was shot: 0 (Auto white balance) or 1 (Manual white balance)
ExifSubIFD.DigitalZoomRatio DOUBLE Digital zoom ratio when the image was shot
ExifSubIFD.FocalLength35 INTEGER Equivalent focal length assuming a 35mm film camera in mm
ExifSubIFD.SceneCaptureType INTEGER Type of scene that was shot: 0 (Standard), 1 (Landscape), 2 (Portrait) or 3 (Night scene)
ExifSubIFD.GainControl INTEGER Degree of overall image gain adjustment: 0 (None), 1 (Low gain up), 2 (Low gain down), 3 (High gain up) or 4 (High gain down)
ExifSubIFD.Contrast INTEGER Direction of contrast processing applied by the camera when the image was shot: 0 (None), 1 (Soft) or 2 (Hard)
ExifSubIFD.Saturation INTEGER Direction of saturation processing applied by the camera when the image was shot: 0 (None), 1 (Low saturation) or 2 (High saturation)
ExifSubIFD.Sharpness INTEGER Direction of sharpness processing applied by the camera when the image was shot: 0 (None), 1 (Low) or 2 (Hard)
ExifSubIFD.DeviceSettingDescription VARBINARY Picture-taking conditions of a particular camera model
ExifSubIFD.SubjectDistanceRange INTEGER distance to the subject: 0 (Unknown), 1 (Macro), 2 (Close view) or 3 (Distant view)
ExifSubIFD.UniqueImageID VARCHAR Identifier assigned uniquely to each image
ExifSubIFD.CameraOwnerName VARCHAR Owner of a camera used in photography
ExifSubIFD.BodySerialNumber VARCHAR Serial number of the body of the camera that was used in photography
ExifSubIFD.LensSpecification[4] DOUBLE Minimum focal length, maximum focal length, minimum F number in the minimum focal length, and minimum F number in the maximum focal length, which are specification information for the lens that was used in photography
ExifSubIFD.LensMake VARCHAR Lens manufacturer
ExifSubIFD.LensModel VARCHAR Lens’s model name and model number
ExifSubIFD.LensSerialNumber VARCHAR Serial number of the interchangeable lens that was used in photography
ExifSubIFD.Gamma DOUBLE Value of coefficient gamma
Interoperability.InteroperabilityIndex VARCHAR Identification of the Interoperability rule:
R98 (DCF basic file)
THM (DCF thumbnail file)
R03 (DCF option file)
Interoperability.InteroperabilityVersion VARCHAR The version is given as a string “0100” to indicate version 1.0
GPS.GPSVersionID[4] INTEGER The version is given as an integer array [2, 2, 0, 0] to indicate version 2.2
GPS.GPSLatitudeRef VARCHAR Indicates whether the latitude is north or south latitude: N (North) or S (South)
GPS.GPSLatitude DOUBLE Latitude in degrees
GPS.GPSLongitudeRef VARCHAR Indicates whether the longitude is east or west longitude: E (East) or W (West)
GPS.GPSLongitude DOUBLE Longitude in degrees
GPS.GPSAltitudeRef INTEGER Reference altitude: 0 (Above Sea Level) or 1 (Below Sea Level)
GPS.GPSAltitude DOUBLE Altitude in meters
GPS.GPSTimeStamp[3] DOUBLE Time as UTC. [hour, minute, second]
GPS.GPSSatellites VARCHAR GPS satellites used for measurements
GPS.GPSStatus VARCHAR Status of the GPS receiver: A (Measurement in progress) or V (Measurement interrupted)
GPS.GPSMeasureMode VARCHAR GPS measurement mode: 2 (2-dimensional measurement) or 3 (3-dimensional measurement)
GPS.GPSDOP DOUBLE GPS DOP (data degree of precision)
GPS.GPSSpeedRef VARCHAR Unit used to express the GPS receiver speed of movement: K (kilometers per hour), M (miles per hour) or N (knots)
GPS.GPSSpeed DOUBLE Speed of GPS receiver movement
GPS.GPSTrackRef VARCHAR Reference for giving the direction of GPS receiver movement: T (True direction) or M (Magnetic direction)
GPS.GPSTrack DOUBLE Direction of GPS receiver movement in degrees
GPS.GPSImgDirectionRef VARCHAR Reference for giving the direction of the image: T (True direction) or M (Magnetic direction)
GPS.GPSImgDirection DOUBLE Direction of the image in degrees
GPS.GPSMapDatum VARCHAR Geodetic survey data used by the GPS receiver
GPS.GPSDestLatitudeRef VARCHAR Indicates whether the latitude of the destination point is north or south latitude: N (North) or S (South)
GPS.GPSDestLatitude[3] DOUBLE Latitude of the destination point in degrees
GPS.GPSDestLongitudeRef VARCHAR Indicates whether the longitude of the destination point is east or west longitude: E (East) or W (West)
GPS.GPSDestLongitude[3] DOUBLE longitude of the destination point in degrees
GPS.GPSDestBearingRef VARCHAR Reference used for giving the bearing to the destination point: T (True direction) or M (Magnetic direction)
GPS.GPSDestBearing DOUBLE Bearing to the destination point in degrees
GPS.GPSDestDistanceRef VARCHAR Unit used to express the distance to the destination point: K (kilometers), M (miles) or N (knots)
GPS.GPSDestDistance DOUBLE Distance to the destination point
GPS.GPSProcessingMethod VARBINARY Name of the method used for location finding
GPS.GPSAreaInformation VARBINARY Name of the GPS area
GPS.GPSDateStamp VARCHAR Date as UTC. The format is “YYYY:MM:DD”
GPS.GPSDifferential INTEGER Indicates whether differential correction is applied to the GPS receiver:
0 (Measurement without differential correction)
1 (Differential correction applied)
GPS.GPSHPositioningError DOUBLE Horizontal positioning errors in meters
ExifThumbnail.Compression INTEGER Compression scheme used for the image data:
1 (Uncompressed)
2 (CCITT 1D)
3 (T4/Group 3 Fax)
4 (T6/Group 4 Fax)
5 (LZW)
6 (JPEG (old-style))
7 (JPEG)
8 (Adobe Deflate)
9 (JBIG B&W)
10 (JBIG Color)
99 (JPEG)
262 (Kodak 262)
32766 (Next)
32767 (Sony ARW Compressed)
32769 (Packed RAW)
32770 (Samsung SRW Compressed)
32771 (CCIRLEW)
32772 (Samsung SRW Compressed 2)
32773 (PackBits)
32809 (Thunderscan)
32867 (Kodak KDC Compressed)
32895 (IT8CTPAD)
32896 (IT8LW)
32897 (IT8MP
32898 (IT8BL)
32908 (PixarFilm)
32909 (PixarLog)
32946 (Deflate)
32947 (DCS)
34661 (JBIG)
34676 (SGILog)
34677 (SGILog24)
34712 (JPEG 2000)
34713 (Nikon NEF Compressed)
34715 (JBIG2 TIFF FX)
34718 (Microsoft Document Imaging (MDI) Binary Level Codec)
34719 (Microsoft Document Imaging (MDI) Progressive Transform Codec)
34720 (Microsoft Document Imaging (MDI) Vector)
34892 (Lossy JPEG)
65000 (Kodak DCR Compressed)
65535 (Pentax PEF Compressed)
ExifThumbnail.XResolution DOUBLE Horizontal pixel resolution
ExifThumbnail.YResolution DOUBLE Vertical pixel resolution
ExifThumbnail.ResolutionUnit INTEGER Resolution unit: 1 (None), 2 (inches) or 3 (cm)
ExifThumbnail.ThumbnailOffset INTEGER Position in the file of thumbnail data
ExifThumbnail.ThumbnailLength INTEGER Length of thumbnail data
XMP.XMPValueCount INTEGER Number of properties in the XMP property tree
XMP.Dc.Contributors[] VARCHAR List of contributors
XMP.Dc.Coverage VARCHAR Extent or scope of the resource
XMP.Dc.Creator[] VARCHAR List of creators
XMP.Dc.Date VARCHAR Point or period of time associated with an event in the life cycle of the resource
XMP.Dc.Description VARCHAR Textual descriptions of the content of the resource
XMP.Dc.Description_<lang> VARCHAR Textual descriptions of the content of the resource, given in various languages
XMP.Dc.Format VARCHAR MIME type of the resource
XMP.Dc.Identifier VARCHAR Unambiguous reference to the resource within a given context
XMP.Dc.Language[] VARCHAR List of languages used in the content of the resource
XMP.Dc.Publisher[] VARCHAR List of publishers
XMP.Dc.Relation[] VARCHAR List of related resources
XMP.Dc.Rights VARCHAR List of informal rights statements
XMP.Dc.Rights_<lang> VARCHAR List of informal rights statements, given in various languages
XMP.Dc.Source VARCHAR Related resource from which the described resource is derived
XMP.Dc.Subject[] VARCHAR List of descriptive phrases or keywords that specify the content of the resource
XMP.Dc.Title VARCHAR Title or name given to the resource
XMP.Dc.Title_<lang> VARCHAR Title or name, given in various languages
XMP.Dc.Type[] VARCHAR Nature or genre of the resource
XMP.Xmp.Advisory[] VARCHAR Unordered array specifying properties that were edited outside the authoring application
XMP.Xmp.BaseURL VARCHAR Base URL for relative URLs in the document content
XMP.Xmp.CreateDate VARCHAR Date and time the resource was created
XMP.Xmp.CreatorTool VARCHAR Name of the first known tool used to create the resource
XMP.Xmp.Identifier[] VARCHAR Unordered array of text strings that unambiguously identify the resource within a given context
XMP.Xmp.Label VARCHAR Word or short phrase that identifies a resource as a member of a user-defined collection
XMP.Xmp.MetadataDate VARCHAR Date and time that any metadata for this resource was last changed
XMP.Xmp.ModifyDate VARCHAR Date and time the resource was last modified
XMP.Xmp.Nickname VARCHAR Short informal name for the resource
XMP.Xmp.Rating VARCHAR User-assigned rating for this file
XMP.XmpRights.Certificate VARCHAR Web URL for a rights management certificate
XMP.XmpRights.Marked VARCHAR When true, indicates that this is a rights-managed resource. When false, indicates that this is a public-domain resource. null if the state is unknown
XMP.XmpRights.Owner VARCHAR List of legal owners of the resource
XMP.XmpRights.UsageTerms VARCHAR Text instructions on how a resource can be legally used
XMP.XmpRights.UsageTerms_<lang> VARCHAR Collection of text instructions on how a resource can be legally used, given in a variety of languages
XMP.XmpRights.WebStatement VARCHAR Web URL for a statement of the ownership and usage rights for this resource
XMP.XmpMM.DerivedFrom.DocumentID VARCHAR Value of the xmpMM:DocumentID property from the referenced resource
XMP.XmpMM.DerivedFrom.FilePath VARCHAR Referenced resource’s file path or URL
XMP.XmpMM.DerivedFrom.InstanceID VARCHAR Value of the xmpMM:InstanceID property from the referenced resource
XMP.XmpMM.DerivedFrom.RenditionClass VARCHAR Value of the xmpMM:RenditionClass property from the referenced resource
XMP.XmpMM.DerivedFrom.RenditionParams VARCHAR value of the xmpMM:RenditionParams property from the referenced resource
XMP.XmpMM.DocumentID VARCHAR Common identifier for all versions and renditions of a resource
XMP.XmpMM:History[].Action VARCHAR Action that occurred
XMP.XmpMM:History[].Changed VARCHAR Semicolon-delimited list of the parts of the document that were changed since the previous event history
XMP.XmpMM:History[].InstanceID VARCHAR Instance ID of the modified resource
XMP.XmpMM:History[].Parameters VARCHAR Additional description of the action
XMP.XmpMM:History[].SoftwareAgent VARCHAR Software agent that performed the action
XMP.XmpMM:History[].When VARCHAR Timestamp of when the action occurred
XMP.XmpMM.InstanceID VARCHAR Identifier for a specific incarnation of a resource, updated each time a file is saved
XMP.XmpMM.Manager VARCHAR Name of the asset management system that manages this resource
XMP.XmpMM.ManageTo VARCHAR URI identifying the managed resource to the asset management system
XMP.XmpMM.ManageUI VARCHAR URI that can be used to access information about the managed resource through a web browser
XMP.XmpMM.ManagerVariant VARCHAR Particular variant of the asset management system
XMP.XmpMM.OriginalDocumentID VARCHAR Common identifier for the original resource from which the current resource is derived
XMP.XmpMM.RenditionClass VARCHAR Rendition class name for this resource
XMP.XmpMM.RenditionParams VARCHAR Additional rendition parameters that are too complex or verbose to encode in xmpMM:RenditionClass
XMP.XmpMM.VersionID VARCHAR Document version identifier for this resource
XMP.XmpMM.Versions[].Comments VARCHAR Comments concerning what was changed
XMP.XmpMM.Versions[].Modifier VARCHAR Person who modified this version
XMP.XmpMM.Versions[].ModifyDate VARCHAR Date on which this version was checked in
XMP.XmpMM.Versions[].Version VARCHAR New version number
XMP.Xmpidq.Scheme VARCHAR Qualifier providing the name of the formal identification scheme used for an item in the xmp:Identifier array
XMP.XmpBJ.JobRef[].Id VARCHAR Unique ID for the job
XMP.XmpBJ.JobRef[].Name VARCHAR Informal name of job
XMP.XmpBJ.JobRef[].Url VARCHAR File URL referencing an external job management file
XMP.Photoshop.AuthorsPosition VARCHAR By-line title
XMP.Photoshop.CaptionWriter VARCHAR Writer/editor
XMP.Photoshop.Category VARCHAR Category. Limited to 3 7-bit ASCII characters
XMP.Photoshop.City VARCHAR City
XMP.Photoshop.ColorMode VARCHAR  
XMP.Photoshop.Country VARCHAR Country/primary location
XMP.Photoshop.Credit VARCHAR Credit
XMP.Photoshop.DateCreated VARCHAR Date the intellectual content of the document was created
XMP.Photoshop.Headline VARCHAR Headline
XMP.Photoshop.History VARCHAR  
XMP.Photoshop.ICCProfile VARCHAR  
XMP.Photoshop.Source VARCHAR Source
XMP.Photoshop.State VARCHAR Province/state
XMP.Photoshop.SupplementalCategories[] VARCHAR Supplemental category
XMP.Photoshop.Urgency VARCHAR Urgency. Valid range is 1-8
XMP.Tiff.Orientation VARCHAR Orientation:
1 (0th row at top, 0th column at left)
2 (0th row at top, 0th column at right)
3 (0th row at bottom, 0th column at right)
4 (0th row at bottom, 0th column at left)
5 (0th row at left, 0th column at top)
6 (0th row at right, 0th column at top)
7 (0th row at right, 0th column at bottom)
8 (0th row at left, 0th column at bottom)
XMP.Tiff.XResolution VARCHAR Horizontal resolution in pixels per unit
XMP.Tiff.YResolution VARCHAR Vertical resolution in pixels per unit
XMP.Tiff.ResolutionUnit VARCHAR Unit used for XResolution and YResolution: 2 (Inches) or 3 (Centimeters)
XMP.Tiff.NativeDigest VARCHAR Digest to detect changes to the TIFF tags
XMP.Exif.ColorSpace VARCHAR Color space information: 1 (sRGB) or 65535 (Uncalibrated)
XMP.Exif.PixelXDimension VARCHAR Valid image width in pixels
XMP.Exif.PixelYDimension VARCHAR Valid image height in pixels
XMP.Exif.NativeDigest VARCHAR Digest to detect changes to the Exif tags
ICCProfile.ProfileSize INTEGER Total size of the profile in bytes
ICCProfile.CMMType VARCHAR Identifies the preferred CMM to be used
ICCProfile.Version INTEGER Profile version number where the first 8 bits are the major version number and the next 8 bits are for the minor version number
ICCProfile.Class VARCHAR Class of device profile:
scnr (Input device)
mntr (Display device)
prtr (Output device)
link (Device link)
spac (Color space conversion)
abst (Abstract)
nmcl (Named color)
ICCProfile.ColorSpace VARCHAR Color space of data:
XYZ  (XYZ)
Lab  (Lab)
Luv  (Luv)
YCbr (YCbCr)
Yxy  (Yxy)
RGB  (RGB)
GRAY (Grayscale)
HSV  (HSV)
HLS  (HLS)
CMYK (CMYK)
CMY  (CMY)
ICCProfile.ProfileConnectionSpace VARCHAR Profile connection space:
XYZ  (XYZ)
Lab  (Lab)
ICCProfile.ProfileDateTime TIMESTAMP Date and time this profile was first created
ICCProfile.Signature VARCHAR Profile file signature : acsp
ICCProfile.PrimaryPlatform VARCHAR Primary platform/operating system framework for which the profile was created:
APPL (Apple Computer, Inc.)
MSFT (Microsoft Corporation)
SGI  (Silicon Graphics, Inc.)
SUNW (Sun Microsystems, Inc.)
TGNT (Taligent, Inc.)
ICCProfile.DeviceManufacturer VARCHAR Device manufacturer of the device for which this profile is created
ICCProfile.DeviceModel VARCHAR Device model of the device for which this profile is created
ICCProfile.RenderingIntent INTEGER Style of reproduction to be used during the evaluation of this profile in a sequence of profiles:
0 (Perceptual)
1 (Relative colorimetric)
2 (Saturation)
3 (Absolute colorimetric)
ICCProfile.XYZValues[3] FLOAT XYZ values of the illuminant of the profile connection space
ICCProfile.TagCount INTEGER Number of tags
ICCProfile.Copyright VARCHAR Profile copyright information
ICCProfile.DeviceMfgDescription VARCHAR Description of device manufacturer
ICCProfile.DeviceModelDescription VARCHAR Description of device model
ICCProfile.ProfileDescription VARCHAR Profile description
ICCProfile.AppleMultiLanguageProfileName VARCHAR Multi-language profile name
ICCProfile.MediaWhitePoint VARCHAR Media white point used for generating absolute colorimetry
ICCProfile.MediaBlackPoint VARCHAR Media black point used for generating absolute colorimetry
ICCProfile.RedTRC VARCHAR Red channel tone reproduction curve
ICCProfile.GreenTRC VARCHAR Green channel tone reproduction curve
ICCProfile.BlueTRC VARCHAR Blue channel tone reproduction curve
ICCProfile.RedColorant VARCHAR Relative XYZ values of red phosphor or colorant
ICCProfile.GreenColorant VARCHAR Relative XYZ values of green phosphor or colorant
ICCProfile.BlueColorant VARCHAR Relative XYZ values of blue phosphor or colorant
JPEG.CompressionType INTEGER Compression type:
0 (Baseline DCT, Huffman coding)
1 (Extended sequential DCT, Huffman coding)
2 (Progressive DCT, Huffman coding)
3 (Lossless, Huffman coding)
5 (Sequential DCT, differential Huffman coding)
6 (Progressive DCT, differential Huffman coding
7 (Lossless, Differential Huffman coding)
9 (Extended sequential DCT, arithmetic coding)
10 (Progressive DCT, arithmetic coding)
11 (Lossless, arithmetic coding)
13 (Sequential DCT, differential arithmetic coding)
14 (Progressive DCT, differential arithmetic coding)
15 (Lossless, differential arithmetic coding)
JPEG.DataPrecision INTEGER Bits per sample
JPEG.ImageHeight INTEGER Image height in pixels
JPEG.ImageWidth INTEGER Image width in pixels
JPEG.NumberOfComponents INTEGER Number of components: 1 (Greyscale), 3 (YCbCr or YIQ) or 4 (CMYK)
JPEG.Component1.ComponentId INTEGER Component identifier: 1 (Y), 2 (Cb), 3 (Cr), 4 (I) or 5 (Q)
JPEG.Component1.HorizontalSamplingFactor INTEGER Horizontal sampling factors
JPEG.Component1.VerticalSamplingFactor INTEGER Vertical sampling factors
JPEG.Component1.QuantizationTableNumber INTEGER Quantization table number
JPEG.Component2.ComponentId INTEGER Component identifier: 1 (Y), 2 (Cb), 3 (Cr), 4 (I) or 5 (Q)
JPEG.Component2.HorizontalSamplingFactor INTEGER Horizontal sampling factors
JPEG.Component2.VerticalSamplingFactor INTEGER Vertical sampling factors
JPEG.Component2.QuantizationTableNumber INTEGER Quantization table number
JPEG.Component3.ComponentId INTEGER Component identifier: 1 (Y), 2 (Cb), 3 (Cr), 4 (I) or 5 (Q)
JPEG.Component3.HorizontalSamplingFactor INTEGER Horizontal sampling factors
JPEG.Component3.VerticalSamplingFactor INTEGER Vertical sampling factors
JPEG.Component3.QuantizationTableNumber INTEGER Quantization table number
JPEG.Component4.ComponentId INTEGER Component identifier: 1 (Y), 2 (Cb), 3 (Cr), 4 (I) or 5 (Q)
JPEG.Component4.HorizontalSamplingFactor INTEGER Horizontal sampling factors
JPEG.Component4.VerticalSamplingFactor INTEGER Vertical sampling factors
JPEG.Component4.QuantizationTableNumber INTEGER Quantization table number
IPTC.EnvelopedRecordVersion INTEGER Version of the Information Interchange Model, Part I, utilised by the provider.
IPTC.Destination VARCHAR Providers who require routing information above the appropriate OSI layers
IPTC.FileFormat VARCHAR File format:
00 (No ObjectData)
01 (IPTC-NAA Digital Newsphoto Parameter Record)
02 (IPTC7901 Recommended Message Format)
03 (Tagged Image File Format (Adobe/Aldus Image data))
04 (Illustrator (Adobe Graphics data))
05 (AppleSingle (Apple Computer Inc))
06 (NAA 89-3 (ANPA 1312))
07 (MacBinary II)
08 (IPTC Unstructured Character Oriented File Format (UCOFF))
09 (United Press International ANPA 1312 variant)
10 (United Press International Down-Load Message)
11 (JPEG File Interchange (JFIF))
12 (Photo-CD Image-Pac (Eastman Kodak))
13 (Microsoft Bit Mapped Graphics File [*.BMP])
14 (Digital Audio File [*.WAV] (Microsoft & Creative Labs))
15 (Audio plus Moving Video [*.AVI] (Microsoft))
16 (PC DOS/Windows Executable Files [*.COM][*.EXE])
17 (Compressed Binary File [*.ZIP] (PKWare Inc))
18 (Audio Interchange File Format AIFF (Apple Computer Inc))
19 (RIFF Wave (Microsoft Corporation))
20 (Freehand (Macromedia/Aldus))
21 (Hypertext Markup Language “HTML” (The Internet Society))
22 (MPEG 2 Audio Layer 2 (Musicom), ISO/IEC)
23 (MPEG 2 Audio Layer 3, ISO/IEC)
24 (Portable Document File (*.PDF) Adobe)
25 (News Industry Text Format (NITF))
26 (Tape Archive (*.TAR))
27 (Tidningarnas Telegrambyrå NITF version (TTNITF DTD))
28 (Ritzaus Bureau NITF version (RBNITF DTD))
29 (Corel Draw [*.CDR])
IPTC.FileVersion INTEGER Particular version of the File Format
IPTC.ServiceIdentifier VARCHAR Provider and product
IPTC.EnvelopeNumber VARCHAR Number that will be unique for the date and for the Service Identifier
IPTC.ProductIdentifier VARCHAR Identifies subsets of provider’s overall service
IPTC.EnvelopePriority VARCHAR Envelope handling priority and not the editorial urgency. 1 indicates the most urgent, 5 the normal urgency, and 8 the least urgent copy. 9 indicates a User Defined Priority
IPTC.DateSent VARCHAR Year, month and day the service sent the material in the form CCYYMMDD (century, year, month, day) as defined in ISO 8601
IPTC.TimeSent VARCHAR Time the service sent the material in the form HHMMSS±HHMM where HHMMSS refers to local hour, minute and seconds and HHMM refers to hours and minutes ahead (+) or behind (-) Universal Coordinated Time as described in ISO 8601
IPTC.CodedCharacterSet VARCHAR One or more control functions used for the announcement, invocation or designation of coded character sets
IPTC.UniqueObjectName VARCHAR Unique Name of Object, providing eternal, globally unique identification for objects as specified in the IIM, independent of provider and for any media form
IPTC.ARMIdentifier VARCHAR Identifies the Abstract Relationship Method (ARM)
IPTC.ARMVersion INTEGER Version of the ARM
IPTC.ApplicationRecordVersion INTEGER Version of the Information Interchange Model, Part II
IPTC.ObjectAttributeReference VARCHAR Nature, intellectual, artistic or journalistic characteristic of an image
IPTC.ObjectName VARCHAR Shorthand reference for the object
IPTC.SubjectReference[] VARCHAR Specifies one or more Subjects from the IPTC Subject-NewsCodes taxonomy to categorise the image
IPTC.Keywords[] VARCHAR Specific information retrieval words
IPTC.SpecialInstructions VARCHAR Other editorial instructions concerning the use of the objectdata
IPTC.DateCreated VARCHAR Date the intellectual content of the objectdata was created in the form CCYYMMDD
IPTC.TimeCreated VARCHAR Time the intellectual content of the objectdata current source material was created in the form HHMMSS±HHMM
IPTC.DigitalDateCreated VARCHAR Date the digital representation of the objectdata was created in the form CCYYMMDD
IPTC.DigitalTimeCreated VARCHAR Time the digital representation of the objectdata was created in the form HHMMSS±HHMM
IPTC.ByLine VARCHAR Name of the creator of the objectdata
IPTC.BylineTitle VARCHAR Job title of the photographer
IPTC.City VARCHAR Name of the city of the location shown in the image
IPTC.SubLocation VARCHAR Exact name of the sublocation shown in the image
IPTC.ProvinceState VARCHAR Name of the subregion of a country of the location shown in the image
IPTC.CountryPrimaryLocationCode VARCHAR Code of the country of the location shown in the image
IPTC.CountryPrimaryLocationName VARCHAR Full name of the country of the location shown in the image
IPTC.OriginalTransmissionReference VARCHAR Number or identifier for the purpose of improved workflow handling
IPTC.CopyrightNotice VARCHAR Copyright notice for claiming the intellectual property for this photograph
IPTC.Headline VARCHAR Brief synopsis of the caption
IPTC.Credit VARCHAR Credit to person(s) and/or organisation(s) required by the supplier of the image to be used when published
IPTC.Source VARCHAR Name of a person or party who has a role in the content supply chain
IPTC.CaptionAbstract VARCHAR Textual description of the objectdata
IPTC.CaptionWriterEditor VARCHAR Name of the person involved in the writing, editing or correcting the objectdata or caption/abstract
IPTC.RasterizedCaption VARCHAR Rasterized objectdata description and is used where characters that have not been coded are required for the caption
IPTC.ImageType VARCHAR Octet 1 indicates number of components in an image:
0 (No objectdata)
1 (Single component)
2 (2 components)
3 (3 components)
4 (4 components)
9 (Supplemental objects related to other objectdata)
Octet 2 indicates the exact content of the current objectdata in terms of colour composition:
W (Monochrome)
Y (Yellow component)
M (Magenta component)
C (Cyan component)
K (Black component)
R (Red component)
G (Green component)
B (Blue component)
T (Text only)
F (Full colour composite, frame sequential)
L (Full colour composite, line sequential)
P (Full colour composite, pixel sequential)
S (Full colour composite, special interleaving)
IPTC.ImageOrientation VARCHAR Layout of the image area: P (Portrait), L (Landscape) or S (Square)
IPTC.LanguageIdentifier VARCHAR Major national language of the object, according to the 2-letter codes of ISO 639:1988
IPTC.AudioType VARCHAR Octet 1 represents the number of channels:
0 (No objectdata)
1 (Monaural (1 channel) audio)
2 (Stereo (2 channel) audio)
Octet 2 indicates the exact type of audio contained in the current objectdata:
A (Actuality)
C (Question and answer session)
M (Music, transmitted by itself)
Q (Response to a question)
R (Raw sound)
S (Scener)
T (Text only)
V (Voicer)
W (Wrap)
IPTC.AudioSamplingRate VARCHAR Six octets with leading zero(s), consisting of Sampling rate numeric characters, representing the sampling rate in hertz (Hz)
IPTC.AudioSamplingResolution VARCHAR Two octets with leading zero(s), consisting of resolution numeric characters representing the number of bits in each audio sample
IPTC.AudioDuration VARCHAR Duration Designates in the form HHMMSS the running time of an audio objectdata when played back at the speed at which it was recorded
IPTC.AudioOutcue VARCHAR Content of the end of an audio objectdata, according to guidelines established by the provider
IPTC.ObjectDataPreviewFileFormat VARCHAR File format of the ObjectData Preview:
00 (No ObjectData)
01 (IPTC-NAA Digital Newsphoto Parameter Record)
02 (IPTC7901 Recommended Message Format)
03 (Tagged Image File Format (Adobe/Aldus Image data))
04 (Illustrator (Adobe Graphics data))
05 (AppleSingle (Apple Computer Inc))
06 (NAA 89-3 (ANPA 1312))
07 (MacBinary II)
08 (IPTC Unstructured Character Oriented File Format (UCOFF))
09 (United Press International ANPA 1312 variant)
10 (United Press International Down-Load Message)
11 (JPEG File Interchange (JFIF))
12 (Photo-CD Image-Pac (Eastman Kodak))
13 (Microsoft Bit Mapped Graphics File [*.BMP])
14 (Digital Audio File [*.WAV] (Microsoft & Creative Labs))
15 (Audio plus Moving Video [*.AVI] (Microsoft))
16 (PC DOS/Windows Executable Files [*.COM][*.EXE])
17 (Compressed Binary File [*.ZIP] (PKWare Inc))
18 (Audio Interchange File Format AIFF (Apple Computer Inc))
19 (RIFF Wave (Microsoft Corporation))
20 (Freehand (Macromedia/Aldus))
21 (Hypertext Markup Language “HTML” (The Internet Society))
22 (MPEG 2 Audio Layer 2 (Musicom), ISO/IEC)
23 (MPEG 2 Audio Layer 3, ISO/IEC)
24 (Portable Document File (*.PDF) Adobe)
25 (News Industry Text Format (NITF))
26 (Tape Archive (*.TAR))
27 (Tidningarnas Telegrambyrå NITF version (TTNITF DTD))
28 (Ritzaus Bureau NITF version (RBNITF DTD))
29 (Corel Draw [*.CDR])
Photoshop.ResolutionInfo VARCHAR ResolutionInfo structure
Photoshop.AlphaChannels VARCHAR Names of the alpha channels
Photoshop.DisplayInfo(Obsolete) VARCHAR DisplayInfo structure
Photoshop.PrintFlags VARCHAR Series of boolean values: Labels, Crop marks, Color bars, Registration marks, Negative, Flip, Interpolate, Caption, Print flags
Photoshop.ColorHalftoningInformation VARCHAR Color halftoning information
Photoshop.ColorTransferFunctions VARCHAR Color transfer functions
Photoshop.EPSOptions VARCHAR EPS options
Photoshop.LayerStateInformation VARCHAR Layer state information. Index of target layer (0 = bottom layer)
Photoshop.LayersGroupInformation VARCHAR Working path (not saved)
Photoshop.JPEGQuality VARCHAR JPEG quality
Photoshop.GridAndGuidesInformation VARCHAR Grid and guides information
Photoshop.CopyrightFlag VARCHAR Whether image is copyrighted
Photoshop.URL VARCHAR Uniform resource locator
Photoshop.ThumbnailData VARCHAR Photoshop 5.0 Thumbnail resource
Photoshop.GlobalAngle VARCHAR Global lighting angle for effects layer
Photoshop.ICCUntaggedProfile VARCHAR ICC Untagged Profile. 1 = intentionally untagged
Photoshop.SeedNumber VARCHAR Document-specific IDs seed number
Photoshop.UnicodeAlphaNames VARCHAR Unicode Alpha Names
Photoshop.GlobalAltitude VARCHAR Global Altitude
Photoshop.Slices VARCHAR Slices
Photoshop.AlphaIdentifiers VARCHAR Alpha Identifiers
Photoshop.URLList VARCHAR URL List. Count of URLs, followed by ID and Unicode string
Photoshop.VersionInfo VARCHAR Version Info. Version, hasRealMergedData, Writer name, Reader name and File version
Photoshop.CaptionDigest VARCHAR RSA Data Security, MD5 message-digest algorithm
Photoshop.PrintScale VARCHAR Print scale. Style: 0 (Centered), 1 (Size to fit) or 2 (User defined), X location, Y location and Scale
Photoshop.PixelAspectRatio VARCHAR Pixel Aspect Ratio. X / Y of a pixel
Photoshop.LayerSelectionIDs VARCHAR Layer Selection ID(s). Count and repeated layer ID
Photoshop.LayerGroupsEnabledID VARCHAR Layer Group(s) Enabled ID. 1 byte for each layer in the document, repeated by length of the resource
Photoshop.PrintInfo2 VARCHAR Information about the current print settings in the document. Color management options
Photoshop.PlugIn*Data VARCHAR Plug-in data
Photoshop.PrintStyle VARCHAR Information about the current print style in the document. Printing marks, labels, ornaments, etc.
Photoshop.PrintFlagsInformation VARCHAR Print flags information. Version: 1, Center crop marks, 0, Bleed width value and Bleed width scale
AdobeJPEG.DCTEncodeVersion INTEGER DCT encode version
AdobeJPEG.Flags0 INTEGER APP14 Flags 0: 0 (None) or 32768 (Encoded with Blend=1 downsampling)
AdobeJPEG.Flags1 INTEGER APP14 Flags 1: 0 (None)
AdobeJPEG.ColorTransform INTEGER Color transform: 0 (Unknown (RGB or CMYK)) , 1 (YCbCr) or 2 (YCCK)
Huffman.NumberOfTables INTEGER Number of Huffman tables
PSDHeader.ChannelCount INTEGER Number of channels
PSDHeader.ImageHeight INTEGER Image height in pixels
PSDHeader.ImageWidth INTEGER Image width in pixels
PSDHeader.BitsPerChannel INTEGER Bits per channel
PSDHeader.ColorMode INTEGER Color mode: 0 (Bitmap), 1 (Grayscale), 2 (Indexed), 3 (RGB), 4 (CMYK), 7 (Multichannel), 8 (Duotone) or 9 (Lab)
PNGIHDR.ImageWidth INTEGER Image width in pixels
PNGIHDR.ImageHeight INTEGER Image height in pixels
PNGIHDR.BitsPerSample INTEGER Number of bits per sample or per palette index: 1, 2, 4, 8 or 16
PNGIHDR.ColorType INTEGER PNG image type:
0 (Greyscale)
2 (True color)
3 (Indexed color)
4 (Greyscale with alpha)
6 (True color with alpha)
PNGIHDR.CompressionType INTEGER Method used to compress the image data: 0 (Deflate/Inflate)
PNGIHDR.FilterMethod INTEGER Preprocessing method applied to the image data before compression: 0 (Adaptive)
PNGIHDR.InterlaceMethod INTEGER Transmission order of the image data: 0 (No interlace) or 1 (Adam7 interlace)
PNGPLTE.PaletteSize INTEGER Number of palette entries
PNGTRNS.PaletteHasTransparency INTEGER 1 if the palette has transparent colors
PNGChromaticities.WhitePointX INTEGER White point, X axis
PNGChromaticities.WhitePointY INTEGER White point, Y axis
PNGChromaticities.RedX INTEGER Chromaticities of red, X axis
PNGChromaticities.RedY INTEGER Chromaticities of red, Y axis
PNGChromaticities.GreenX INTEGER Chromaticities of green, X axis
PNGChromaticities.GreenY INTEGER Chromaticities of green, Y axis
PNGChromaticities.BlueX INTEGER Chromaticities of blue, X axis
PNGChromaticities.BlueY INTEGER Chromaticities of blue, Y axis
PNGGAMA.ImageGamma DOUBLE Gamma
PNGICCP.ICCProfileName VARCHAR Name for referring to the profile
PNGSBIT.SignificantBits[] INTEGER Original number of significant bits
PNGSRGB.SRGBRenderingIntent INTEGER Rendering intent: 0 (Perceptual), 1 (Relative Colorimetric), 2 (Saturation) or 3 (Absolute Colorimetric)
PNGTEXt.TextualData[] MAP Pairs of keyword and text string
PNGZTXt.TextualData[] MAP Pairs of keyword and text string
PNGBKGD.BackgroundColor VARBINARY Default background colour to present the image against
PNGPHYs.PixelsPerUnitX INTEGER Pixels per unit, X axis
PNGPHYs.PixelsPerUnitY INTEGER Pixels per unit, Y axis
PNGPHYs.UnitSpecifier INTEGER Unit specifier: 0 (Unspecified) or 1 (Metres)
PNGTIME.LastModificationTime TIMESTAMP Time of the last image modification
GIFHeader.GIFFormatVersion VARCHAR Version number
GIFHeader.ImageWidth INTEGER Logical screen width in pixels
GIFHeader.ImageHeight INTEGER Logical screen height in pixels
GIFHeader.ColorTableSize INTEGER Size of the Global Color Table
GIFHeader.IsColorTableSorted BOOLEAN Whether the Global Color Table is sorted
GIFHeader.BitsPerPixel INTEGER Number of bits per primary color available to the original image
GIFHeader.HasGlobalColorTable BOOLEAN Indicates the presence of a Global Color Table
GIFHeader.BackgroundColorIndex INTEGER Color used for those pixels on the screen that are not covered by an image
GIFHeader.PixelAspectRatio FLOAT Factor used to compute an approximation of the aspect ratio of the pixel in the original image
GIFControl.DisposalMethod VARCHAR Way in which the graphic is to be treated after being displayed:
Don't Dispose
Not Specified
Restore to Background Color
Restore to Previous
To Be Defined
GIFControl.UserInputFlag BOOLEAN Whether or not user input is expected before continuing
GIFControl.TransparentColorFlag BOOLEAN Whether a transparency index is given in the Transparent Index field
GIFControl.Delay INTEGER Number of hundredths (1/100) of a second to wait before continuing with the processing of the Data Stream
GIFControl.TransparentColorIndex INTEGER Color used for those pixel of the display device is not modified and processing goes on to the next pixel
GIFAnimation.IterationCount INTEGER Number of iterations the animated GIF should be executed
GIFImage.Left INTEGER Column number, in pixels, of the left edge of the image, with respect to the left edge of the Logical Screen
GIFImage.Top INTEGER Row number, in pixels, of the top edge of the image with respect to the top edge of the Logical Screen
GIFImage.Width INTEGER Width of the image in pixels
GIFImage.Height INTEGER Height of the image in pixels
GIFImage.HasLocalColourTable BOOLEAN Indicates the presence of a Local Color Table
GIFImage.IsInterlaced BOOLEAN Whether the image is interlaced
ICO.ImageType INTEGER Image type: 1 (Icon) or 2 (Cursor)
ICO.ImageWidth INTEGER Image width in pixels
ICO.ImageHeight INTEGER Image height in pixels
ICO.ColourPaletteSize INTEGER Number of colors in the color palette
ICO.ColourPlanes INTEGER Number of colour planes (only for icon)
ICO.BitsPerPixel INTEGER Bits per pixel (only for icon)
ICO.HotspotX INTEGER Horizontal coordinates of the hotspot in number of pixels from the left (only for cursor)
ICO.HotspotY INTEGER Vertical coordinates of the hotspot in number of pixels from the top (only for cursor)
ICO.ImageSizeBytes INTEGER Size of the image’s data in bytes
ICO.ImageOffsetBytes INTEGER Cffset of BMP or PNG data from the beginning of the ICO/CUR file
PCX.Version INTEGER PCX Paintbrush version:
0 (2.5 with fixed EGA palette information)
2 (2.8 with modifiable EGA palette information)
3 (2.8 without palette information (default palette))
4 (PC Paintbrush for Windows)
5 (3.0 or better)
PCX.BitsPerPixel INTEGER Number of bits per pixel in each colour plane
PCX.XMin INTEGER Column number, in pixels, of the left edge of the image
PCX.YMin INTEGER Row number, in pixels, of the top edge of the image
PCX.XMax INTEGER Column number, in pixels, of the right edge of the image
PCX.YMax INTEGER Row number, in pixels, of the bottom edge of the image
PCX.HorizontalDPI INTEGER Horizontal resolution, in DPI (dots per inch)
PCX.VerticalDPI INTEGER Vertical resolution, in DPI (dots per inch)
PCX.Palette VARBINARY For 16 colors or less, entries of RGB for the palette, similar to bitmap palette, but each entry 3 bytes long only
PCX.ColorPlanes INTEGER Number of colour planes: 3 (24-bit color) or 4 (16 colors)
PCX.BytesPerLine INTEGER Number of bytes to read for a single plane’s scanline
PCX.PaletteType INTEGER How to interpret palette: 1 (Color or B&W) or 2 (Grayscale)
PCX.HScrSize INTEGER Horizontal scrolling size
PCX.VScrSize INTEGER Vertical scrolling size
WAV.BitsPerSample INTEGER Bits per sample
WAV.Format VARCHAR Audio format name
WAV.Channels INTEGER Number of channels
WAV.SamplesPerSecond INTEGER Samples per second
WAV.BytesPerSecond INTEGER Bytes per second
WAV.BlockAlignment INTEGER Number of bytes for one sample including all channels
WAV.Software VARCHAR Name of the software used to generate the data
WAV.Duration VARCHAR Duration
AVI.FramesPerSecond DOUBLE Frames per second
AVI.SamplesPerSecond DOUBLE Samples per second
AVI.Duration VARCHAR Duration
AVI.VideoCodec VARCHAR Video codec
AVI.Width INTEGER Width of video stream
AVI.Height INTEGER Height of video stream
AVI.StreamCount INTEGER Number of streams in the file
WebP.ImageWidth INTEGER Image width in pixels
WebP.ImageHeight INTEGER Image height in pixels
WebP.HasAlpha BOOLEAN true if any of the frames of the image contain transparency information (“alpha”)
WebP.IsAnimation BOOLEAN true if this is an animated image
QuickTime.MajorBrand VARCHAR Major file format brand:
3g2a (3GPP2 Media (.3G2) compliant with 3GPP2 C.S0050-0 V1.0)
3g2b (3GPP2 Media (.3G2) compliant with 3GPP2 C.S0050-A V1.0.0)
3g2c (3GPP2 Media (.3G2) compliant with 3GPP2 C.S0050-B v1.0)
3ge6 (3GPP (.3GP) Release 6 MBMS Extended Presentations)
3ge7 (3GPP (.3GP) Release 7 MBMS Extended Presentations)
3gg6 (3GPP Release 6 General Profile)
3gp1 (3GPP Media (.3GP) Release 1 (probably non-existent))
3gp2 (3GPP Media (.3GP) Release 2 (probably non-existent))
3gp3 (3GPP Media (.3GP) Release 3 (probably non-existent))
3gp4 (3GPP Media (.3GP) Release 4)
3gp5 (3GPP Media (.3GP) Release 5)
3gp6 (3GPP Media (.3GP) Release 6 Basic Profile)
3gp6 (3GPP Media (.3GP) Release 6 Progressive Download)
3gp6 (3GPP Media (.3GP) Release 6 Streaming Servers)
3gs7 (3GPP Media (.3GP) Release 7 Streaming Servers)
avc1 (MP4 Base w/ AVC ext [ISO 14496-12:2005])
CAEP (Canon Digital Camera)
caqv (Casio Digital Camera)
CDes (Convergent Design)
da0a (DMB MAF w/ MPEG Layer II aud, MOT slides, DLS, JPG/PNG/MNG images)
da0b (DMB MAF, extending DA0A, with 3GPP timed text, DID, TVA, REL, IPMP)
da1a (DMB MAF audio with ER-BSAC audio, JPG/PNG/MNG images)
da1b (DMB MAF, extending da1a, with 3GPP timed text, DID, TVA, REL, IPMP)
da2a (DMB MAF aud w/ HE-AAC v2 aud, MOT slides, DLS, JPG/PNG/MNG images)
da2b (DMB MAF, extending da2a, with 3GPP timed text, DID, TVA, REL, IPMP)
da3a (DMB MAF aud with HE-AAC aud, JPG/PNG/MNG images)
da3b (DMB MAF, extending da3a w/ BIFS, 3GPP timed text, DID, TVA, REL, IPMP)
dmb1 (DMB MAF supporting all the components defined in the specification)
dmpf (Digital Media Project)
drc1 (Dirac (wavelet compression), encapsulated in ISO base media (MP4))
dv1a (DMB MAF vid w/ AVC vid, ER-BSAC aud, BIFS, JPG/PNG/MNG images, TS)
dv1b (DMB MAF, extending dv1a, with 3GPP timed text, DID, TVA, REL, IPMP)
dv2a (DMB MAF vid w/ AVC vid, HE-AAC v2 aud, BIFS, JPG/PNG/MNG images, TS)
dv2b (DMB MAF, extending dv2a, with 3GPP timed text, DID, TVA, REL, IPMP)
dv3a (DMB MAF vid w/ AVC vid, HE-AAC aud, BIFS, JPG/PNG/MNG images, TS)
dv3b (DMB MAF, extending dv3a, with 3GPP timed text, DID, TVA, REL, IPMP)
dvr1 (DVB (.DVB) over RTP)
dvt1 (DVB (.DVB) over MPEG-2 Transport Stream)
F4V  (Video for Adobe Flash Player 9+ (.F4V))
F4P  (Protected Video for Adobe Flash Player 9+ (.F4P))
F4A  (Audio for Adobe Flash Player 9+ (.F4A))
F4B  (Audio Book for Adobe Flash Player 9+ (.F4B))
isc2 (ISMACryp 2.0 Encrypted File)
iso2 (MP4 Base Media v2 [ISO 14496-12:2005])
isom (MP4 Base Media v1 [IS0 14496-12:2003])
JP2  (JPEG 2000 Image (.JP2) [ISO 15444-1 ?])
JP20 (Unknown, from GPAC samples (prob non-existent))
jpm  (JPEG 2000 Compound Image (.JPM) [ISO 15444-6])
jpx  (JPEG 2000 w/ extensions (.JPX) [ISO 15444-2])
KDDI (3GPP2 EZmovie for KDDI 3G cellphones)
M4A  (Apple iTunes AAC-LC (.M4A) Audio)
M4B  (Apple iTunes AAC-LC (.M4B) Audio Book)
M4P  (Apple iTunes AAC-LC (.M4P) AES Protected Audio)
M4V  (Apple iTunes Video (.M4V) Video)
M4VH (Apple TV (.M4V))
M4VP (Apple iPhone (.M4V))
mj2s (Motion JPEG 2000 [ISO 15444-3] Simple Profile)
mjp2 (Motion JPEG 2000 [ISO 15444-3] General Profile)
mmp4 (MPEG-4/3GPP Mobile Profile (.MP4 / .3GP) (for NTT))
mp21 (MPEG-21 [ISO/IEC 21000-9])
mp41 (MP4 v1 [ISO 14496-1:ch13])
mp42 (MP4 v2 [ISO 14496-14])
mp71 (MP4 w/ MPEG-7 Metadata [per ISO 14496-12])
MPPI (Photo Player, MAF [ISO/IEC 23000-3])
mqt  (Sony / Mobile QuickTime (.MQV) US Patent 7,477,830 (Sony Corp))
MSNV (MPEG-4 (.MP4) for SonyPSP)
NDAS (MP4 v2 [ISO 14496-14] Nero Digital AAC Audio)
NDSC (MPEG-4 (.MP4) Nero Cinema Profile)
NDSH (MPEG-4 (.MP4) Nero HDTV Profile)
NDSM (MPEG-4 (.MP4) Nero Mobile Profile)
NDSP (MPEG-4 (.MP4) Nero Portable Profile)
NDSS (MPEG-4 (.MP4) Nero Standard Profile)
NDXC (H.264/MPEG-4 AVC (.MP4) Nero Cinema Profile)
NDXH (H.264/MPEG-4 AVC (.MP4) Nero HDTV Profile)
NDXM (H.264/MPEG-4 AVC (.MP4) Nero Mobile Profile)
NDXP (H.264/MPEG-4 AVC (.MP4) Nero Portable Profile)
NDXS (H.264/MPEG-4 AVC (.MP4) Nero Standard Profile)
odcf (OMA DCF DRM Format 2.0 (OMA-TS-DRM-DCF-V2_0-20060303-A))
opf2 (OMA PDCF DRM Format 2.1 (OMA-TS-DRM-DCF-V2_1-20070724-C))
opx2 (OMA PDCF DRM + XBS extensions (OMA-TS-DRM_XBS-V1_0-20070529-C))
pana (Panasonic Digital Camera)
qt   (Apple QuickTime (.MOV/QT))
ROSS (Ross Video)
sdv  (SD Memory Card Video)
ssc1 (Samsung stereoscopic, single stream (patent pending, see notes))
ssc2 (Samsung stereoscopic, dual stream (patent pending, see notes))
QuickTime.MinorVersion INTEGER File format specification version
QuickTime.CompatibleBrands[] VARCHAR Compatible file format brands
QuickTime.CreationTime TIMESTAMP Date and time when the movie atom was created
QuickTime.ModificationTime TIMESTAMP Date and time when the movie atom was changed
QuickTime.Duration INTEGER Duration of the movie in time scale units
QuickTime.MediaTimeScale INTEGER Time scale for this movie — that is, the number of time units that pass per second in its time coordinate system. A time coordinate system that measures time in sixtieths of a second, for example, has a time scale of 60
QuickTime.TransformationMatrix[9] INTEGER The matrix structure associated with this movie. A matrix shows how to map points from one coordinate space into another
QuickTime.PreferredRate DOUBLE Rate at which to play this movie. A value of 1.0 indicates normal rate
QuickTime.PreferredVolume DOUBLE How loud to play this movie’s sound. A value of 1.0 indicates full volume
QuickTime.PreviewTime INTEGER Time value in the movie at which the preview begins
QuickTime.PreviewDuration INTEGER Duration of the movie preview in movie time scale units
QuickTime.PosterTime INTEGER Time value of the time of the movie poster
QuickTime.SelectionTime INTEGER Time value for the start time of the current selection
QuickTime.SelectionDuration INTEGER Duration of the current selection in movie time scale units
QuickTime.CurrentTime INTEGER Time value for current time position within the movie
QuickTime.NextTrackID INTEGER Value to use for the track ID number of the next track added to this movie
QuickTimeVideo.CreationTime TIMESTAMP Date and time when the media atom was created
QuickTimeVideo.ModificationTime TIMESTAMP Date and time when the media atom was changed
QuickTimeVideo.Opcolor[3] INTEGER Red, green, and blue colors for the transfer mode operation indicated in the graphics mode field
QuickTimeVideo.GraphicsMode INTEGER Transfer mode that specifies which Boolean operation QuickDraw should perform when drawing or transferring an image from one location to another:
0x0 (Copy)
0x20 (Blend)
0x24 (Transparent)
0x40 (Dither copy)
0x100 (Straight alpha)
0x101 (Premul white alpha)
0x102 (Premul black alpha)
0x103 (Composition (dither copy))
0x104 (Straight alpha blend)
QuickTimeVideo.Vendor VARCHAR Developer of the compressor that generated the compressed data
QuickTimeVideo.CompressionType VARCHAR Type of compression that was used to compress the image data, or the color space representation of uncompressed video data
QuickTimeVideo.TemporalQuality INTEGER Degree of temporal compression. A value from 0 to 1023
QuickTimeVideo.SpatialQuality INTEGER Degree of spatial compression. A value from 0 to 1024
QuickTimeVideo.Width INTEGER Width of the source image in pixels
QuickTimeVideo.Height INTEGER Height of the source image in pixels
QuickTimeVideo.CompressorName VARCHAR Name of the compressor that created the image
QuickTimeVideo.Depth INTEGER Pixel depth of the compressed image. Values of 1, 2, 4, 8 ,16, 24, and 32 indicate the depth of color images. The value 32 should be used only if the image contains an alpha channel. Values of 34, 36, and 40 indicate 2-, 4-, and 8-bit grayscale, respectively, for grayscale images
QuickTimeVideo.ColorTable INTEGER Color table ID. If this field is set to –1, the default color table should be used for the specified depth. For all depths below 16 bits per pixel, this indicates a standard Macintosh color table for the specified depth. Depths of 16, 24, and 32 have no color table
QuickTimeVideo.HorizontalResolution DOUBLE Horizontal resolution of the image in pixels per inch
QuickTimeVideo.VerticalResolution DOUBLE Vertical resolution of the image in pixels per inch
QuickTimeSound.CreationTime TIMESTAMP Date and time when the media atom was created
QuickTimeSound.ModificationTime TIMESTAMP Date and time when the media atom was changed
QuickTimeSound.Balance DOUBLE Sound balance of this sound media
QuickTimeSound.Format VARCHAR Format of the audio data. This may specify a compression format or one of several uncompressed audio formats
QuickTimeSound.NumberOfChannels INTEGER Number of sound channels used by the sound sample: 1 (Monaural sounds) or 2 (Stereo sounds)
QuickTimeSound.SampleSize INTEGER Number of bits in each uncompressed sound sample. Allowable values are 8 or 16
QuickTimeSound.SampleRate DOUBLE Rate at which the sound samples were obtained
QuickTimeMetadata.ISO6709 VARCHAR Geographic point location by coordinates as defined in ISO 6709:2008
QuickTimeMetadata.Make VARCHAR Manufacturer of the recording equipment
QuickTimeMetadata.Model VARCHAR Model of the recording equipment
QuickTimeMetadata.Software VARCHAR Name of software used to create the movie file content
QuickTimeMetadata.CreationDate VARCHAR Date the movie file content was created
QuickTimeMetadata.PixelDensity[4] INTEGER Pixel Density
MP4.MajorBrand VARCHAR Major file format brand:
3g2a (3GPP2 Media (.3G2) compliant with 3GPP2 C.S0050-0 V1.0)
3g2b (3GPP2 Media (.3G2) compliant with 3GPP2 C.S0050-A V1.0.0)
3g2c (3GPP2 Media (.3G2) compliant with 3GPP2 C.S0050-B v1.0)
3ge6 (3GPP (.3GP) Release 6 MBMS Extended Presentations)
3ge7 (3GPP (.3GP) Release 7 MBMS Extended Presentations)
3gg6 (3GPP Release 6 General Profile)
3gp1 (3GPP Media (.3GP) Release 1 (probably non-existent))
3gp2 (3GPP Media (.3GP) Release 2 (probably non-existent))
3gp3 (3GPP Media (.3GP) Release 3 (probably non-existent))
3gp4 (3GPP Media (.3GP) Release 4)
3gp5 (3GPP Media (.3GP) Release 5)
3gp6 (3GPP Media (.3GP) Release 6 Basic Profile)
3gp6 (3GPP Media (.3GP) Release 6 Progressive Download)
3gp6 (3GPP Media (.3GP) Release 6 Streaming Servers)
3gs7 (3GPP Media (.3GP) Release 7 Streaming Servers)
avc1 (MP4 Base w/ AVC ext [ISO 14496-12:2005])
CAEP (Canon Digital Camera)
caqv (Casio Digital Camera)
CDes (Convergent Design)
da0a (DMB MAF w/ MPEG Layer II aud, MOT slides, DLS, JPG/PNG/MNG images)
da0b (DMB MAF, extending DA0A, with 3GPP timed text, DID, TVA, REL, IPMP)
da1a (DMB MAF audio with ER-BSAC audio, JPG/PNG/MNG images)
da1b (DMB MAF, extending da1a, with 3GPP timed text, DID, TVA, REL, IPMP)
da2a (DMB MAF aud w/ HE-AAC v2 aud, MOT slides, DLS, JPG/PNG/MNG images)
da2b (DMB MAF, extending da2a, with 3GPP timed text, DID, TVA, REL, IPMP)
da3a (DMB MAF aud with HE-AAC aud, JPG/PNG/MNG images)
da3b (DMB MAF, extending da3a w/ BIFS, 3GPP timed text, DID, TVA, REL, IPMP)
dmb1 (DMB MAF supporting all the components defined in the specification)
dmpf (Digital Media Project)
drc1 (Dirac (wavelet compression), encapsulated in ISO base media (MP4))
dv1a (DMB MAF vid w/ AVC vid, ER-BSAC aud, BIFS, JPG/PNG/MNG images, TS)
dv1b (DMB MAF, extending dv1a, with 3GPP timed text, DID, TVA, REL, IPMP)
dv2a (DMB MAF vid w/ AVC vid, HE-AAC v2 aud, BIFS, JPG/PNG/MNG images, TS)
dv2b (DMB MAF, extending dv2a, with 3GPP timed text, DID, TVA, REL, IPMP)
dv3a (DMB MAF vid w/ AVC vid, HE-AAC aud, BIFS, JPG/PNG/MNG images, TS)
dv3b (DMB MAF, extending dv3a, with 3GPP timed text, DID, TVA, REL, IPMP)
dvr1 (DVB (.DVB) over RTP)
dvt1 (DVB (.DVB) over MPEG-2 Transport Stream)
F4V  (Video for Adobe Flash Player 9+ (.F4V))
F4P  (Protected Video for Adobe Flash Player 9+ (.F4P))
F4A  (Audio for Adobe Flash Player 9+ (.F4A))
F4B  (Audio Book for Adobe Flash Player 9+ (.F4B))
isc2 (ISMACryp 2.0 Encrypted File)
iso2 (MP4 Base Media v2 [ISO 14496-12:2005])
isom (MP4 Base Media v1 [IS0 14496-12:2003])
JP2  (JPEG 2000 Image (.JP2) [ISO 15444-1 ?])
JP20 (Unknown, from GPAC samples (prob non-existent))
jpm  (JPEG 2000 Compound Image (.JPM) [ISO 15444-6])
jpx  (JPEG 2000 w/ extensions (.JPX) [ISO 15444-2])
KDDI (3GPP2 EZmovie for KDDI 3G cellphones)
M4A  (Apple iTunes AAC-LC (.M4A) Audio)
M4B  (Apple iTunes AAC-LC (.M4B) Audio Book)
M4P  (Apple iTunes AAC-LC (.M4P) AES Protected Audio)
M4V  (Apple iTunes Video (.M4V) Video)
M4VH (Apple TV (.M4V))
M4VP (Apple iPhone (.M4V))
mj2s (Motion JPEG 2000 [ISO 15444-3] Simple Profile)
mjp2 (Motion JPEG 2000 [ISO 15444-3] General Profile)
mmp4 (MPEG-4/3GPP Mobile Profile (.MP4 / .3GP) (for NTT))
mp21 (MPEG-21 [ISO/IEC 21000-9])
mp41 (MP4 v1 [ISO 14496-1:ch13])
mp42 (MP4 v2 [ISO 14496-14])
mp71 (MP4 w/ MPEG-7 Metadata [per ISO 14496-12])
MPPI (Photo Player, MAF [ISO/IEC 23000-3])
mqt  (Sony / Mobile QuickTime (.MQV) US Patent 7,477,830 (Sony Corp))
MSNV (MPEG-4 (.MP4) for SonyPSP)
NDAS (MP4 v2 [ISO 14496-14] Nero Digital AAC Audio)
NDSC (MPEG-4 (.MP4) Nero Cinema Profile)
NDSH (MPEG-4 (.MP4) Nero HDTV Profile)
NDSM (MPEG-4 (.MP4) Nero Mobile Profile)
NDSP (MPEG-4 (.MP4) Nero Portable Profile)
NDSS (MPEG-4 (.MP4) Nero Standard Profile)
NDXC (H.264/MPEG-4 AVC (.MP4) Nero Cinema Profile)
NDXH (H.264/MPEG-4 AVC (.MP4) Nero HDTV Profile)
NDXM (H.264/MPEG-4 AVC (.MP4) Nero Mobile Profile)
NDXP (H.264/MPEG-4 AVC (.MP4) Nero Portable Profile)
NDXS (H.264/MPEG-4 AVC (.MP4) Nero Standard Profile)
odcf (OMA DCF DRM Format 2.0 (OMA-TS-DRM-DCF-V2_0-20060303-A))
opf2 (OMA PDCF DRM Format 2.1 (OMA-TS-DRM-DCF-V2_1-20070724-C))
opx2 (OMA PDCF DRM + XBS extensions (OMA-TS-DRM_XBS-V1_0-20070529-C))
pana (Panasonic Digital Camera)
qt   (Apple QuickTime (.MOV/QT))
ROSS (Ross Video)
sdv  (SD Memory Card Video)
ssc1 (Samsung stereoscopic, single stream (patent pending, see notes))
ssc2 (Samsung stereoscopic, dual stream (patent pending, see notes))
MP4.MinorVersion INTEGER File format specification version
MP4.CompatibleBrands[] VARCHAR Compatible file format brands
MP4.CreationTime TIMESTAMP Date and time when the movie box was created
MP4.ModificationTime TIMESTAMP Date and time when the movie atom was changed
MP4.Duration INTEGER Duration of the movie in time scale units
MP4.MediaTimeScale INTEGER Time scale for this movie — that is, the number of time units that pass per second in its time coordinate system. A time coordinate system that measures time in sixtieths of a second, for example, has a time scale of 60
MP4.TransformationMatrix[9] INTEGER The matrix structure associated with this movie. A matrix shows how to map points from one coordinate space into another
MP4.PreferredRate DOUBLE Rate at which to play this movie. A value of 1.0 indicates normal rate
MP4.PreferredVolume DOUBLE How loud to play this movie’s sound. A value of 1.0 indicates full volume
MP4.NextTrackID INTEGER Value to use for the track ID number of the next track added to this movie
MP4Video.Vendor VARCHAR Developer of the compressor that generated the compressed data
MP4Video.TemporalQuality INTEGER Degree of temporal compression. A value from 0 to 1023
MP4Video.Width INTEGER Width of the source image in pixels
MP4Video.Height INTEGER Height of the source image in pixels
MP4Video.Opcolor[3] INTEGER Red, green, and blue colors for the transfer mode operation indicated in the graphics mode field
MP4Video.GraphicsMode INTEGER Transfer mode that specifies which Boolean operation QuickDraw should perform when drawing or transferring an image from one location to another:
0x0 (Copy)
0x20 (Blend)
0x24 (Transparent)
0x40 (Dither copy)
0x100 (Straight alpha)
0x101 (Premul white alpha)
0x102 (Premul black alpha)
0x103 (Composition (dither copy))
0x104 (Straight alpha blend)
MP4Video.CompressionType VARCHAR Type of compression that was used to compress the image data, or the color space representation of uncompressed video data
MP4Video.Depth INTEGER Pixel depth of the compressed image. Values of 1, 2, 4, 8 ,16, 24, and 32 indicate the depth of color images. The value 32 should be used only if the image contains an alpha channel. Values of 34, 36, and 40 indicate 2-, 4-, and 8-bit grayscale, respectively, for grayscale images
MP4Video.HorizontalResolution DOUBLE Horizontal resolution of the image in pixels per inch
MP4Video.VerticalResolution DOUBLE Vertical resolution of the image in pixels per inch
MP4Video.FrameRate FLOAT Frame rate
MP4Sound.Format VARCHAR Format of the audio data. This may specify a compression format or one of several uncompressed audio formats
MP4Sound.NumberOfChannels INTEGER Number of sound channels used by the sound sample: 1 (Monaural sounds) or 2 (Stereo sounds)
MP4Sound.SampleRate DOUBLE Rate at which the sound samples were obtained
MP4Sound.Balance DOUBLE Sound balance of this sound media
MP4Sound.SampleSize INTEGER Number of bits in each uncompressed sound sample. Allowable values are 8 or 16
EPS.TIFFPreviewSize INTEGER Byte length of TIFF section
EPS.TIFFPreviewOffset INTEGER Byte position of TIFF representation
EPS.WMFPreviewSize INTEGER Byte length of Metafile section (PSize)
EPS.WMFPreviewOffset INTEGER Byte position in file for start of Metafile screen representation
EPS.BoundingBox VARCHAR Bounding box that encloses all marks painted on all pages of a document
EPS.Copyright VARCHAR Copyright information associated with the docu- ment or resource
EPS.Creator VARCHAR Document creator, usually the name of the document composition software
EPS.CreationDate VARCHAR Date and time the document was created
EPS.DocumentData VARCHAR Type of data: Clean7Bit, Clean8Bit or Binary
EPS.Emulation VARCHAR Indicates that the document contains an invocation of the stated emulator: diablo630, fx100, lj2000, hpgl, impress, hplj or ti855
EPS.Extensions VARCHAR Indicates that in order to print properly, the document requires a PostScript Level 1 interpreter that supports the listed PostScript language extensions: DPS, CMYK, Composite or FileSystem
EPS.For VARCHAR Person and possibly the company name for whom the document is being printed
EPS.LanguageLevel VARCHAR Indicates that the document contains PostScript language operators particular to a certain level of implementation of the PostScript language
EPS.Orientation VARCHAR Orientation of the pages in the document: Portrait or Landscape
EPS.Pages VARCHAR Number of virtual pages that a document will image
EPS.PageOrder VARCHAR Order of pages in the document file: Ascend, Descend or Special
EPS.Routing VARCHAR Information about how to route a document back to its owner after printing
EPS.Title VARCHAR Text title for the document that is useful for printing banner pages and for routing or recognizing documents
EPS.Version VARCHAR Version and revision number of a document or resource
EPS.OperatorIntervention VARCHAR Password that the print operator must supply to release the job
EPS.OperatorMessage VARCHAR Message that the document manager can display on the console before printing the job
EPS.ProofMode VARCHAR Level of accuracy that is required for printing: TrustMe, Substitute or NotifyMe
EPS.Requirements VARCHAR Document requirements, such as duplex printing, hole punching, collating, or other physical document processing needs
EPS.VMLocation VARCHAR Whether a resource can be loaded into global or local VM: global or local
EPS.VMusage VARCHAR Amount of VM storage this resource consumes
EPS.ImageData VARCHAR %ImageData comment
EPS.ImageWidth INTEGER Width of the image in pixels
EPS.ImageHeight INTEGER Height of the image in pixels
EPS.ColorType INTEGER Color type: 1 (Bitmap/grayscale), 2 (Lab), 3: RGB or 4 (CMYK)
EPS.RamSize INTEGER Ram Size to keep the image in bytes