# photo-video-base exif planning 20230818

### DSLR fields

- shoot
- short string
- FileSize
- short string
- FileType
- short string
- ImageWidth
- number
- ImageHeight
- number
- Make
- short string
- Model
- short string
- ExposureTime
- short string
- FNumber
- number
- ISO
- number
- FocalLength
- short string
- ColorSpace
- short string
- LensModel
- short string
- json
- long string

### iPhone fields

- shoot
- short string
- FileSize
- short string
- FileType
- short string
- ImageWidth
- number
- ImageHeight
- number
- Make
- short string
- Model
- short string
- ExposureTime
- short string
- FNumber
- number
- ISO
- number
- FocalLength
- short string
- ColorSpace
- short string
- LensModel
- short string
- json
- long string
- GPSImgDirectionRef
- short string
- GPSDestBearingRef
- short string
- GPSDestBearing
- short string
- GPSDateStamp
- short string
- GPSHPositioningError
- short string
- GPSAltitude
- short string
- GPSLatitude
- short string
- GPSLongitude
- short string
- GPSPosition
- short string

### .cr2 Exif Data

{
    "SourceFile": "/Volumes/sdx.1000/_ingest/2023_06/20/20230620.0.1330_NAHSP.Storytelling.Workshop/5d.a.stills/20230620.0.1330_NAHSP.Storytelling.Workshop_5d.a.stills.0002.CR2",
    "ExifToolVersion": 12.3,
    "FileName": "20230620.0.1330_NAHSP.Storytelling.Workshop_5d.a.stills.0002.CR2",
    "Directory": "/Volumes/sdx.1000/_ingest/2023_06/20/20230620.0.1330_NAHSP.Storytelling.Workshop/5d.a.stills",
    "FileSize": "27 MiB",
    "FileModifyDate": "2023:06:20 13:21:43-04:00",
    "FileAccessDate": "2023:07:14 16:44:24-04:00",
    "FileInodeChangeDate": "2023:07:11 14:53:08-04:00",
    "FilePermissions": "-rwxrwxrwx",
    "FileType": "CR2",
    "FileTypeExtension": "cr2",
    "MIMEType": "image/x-canon-cr2",
    "ExifByteOrder": "Little-endian (Intel, II)",
    "ImageWidth": 6720,
    "ImageHeight": 4480,
    "BitsPerSample": "8 8 8",
    "Compression": "JPEG (old-style)",
    "Make": "Canon",
    "Model": "Canon EOS 5D Mark IV",
    "PreviewImageStart": 61616,
    "Orientation": "Horizontal (normal)",
    "PreviewImageLength": 815042,
    "XResolution": 72,
    "YResolution": 72,
    "ResolutionUnit": "inches",
    "ModifyDate": "2023:06:20 13:21:41",
    "Artist": "",
    "Rating": 0,
    "Copyright": "",
    "ExposureTime": "1/200",
    "FNumber": 2.8,
    "ExposureProgram": "Manual",
    "ISO": 160,
    "SensitivityType": "Recommended Exposure Index",
    "RecommendedExposureIndex": 160,
    "ExifVersion": "0230",
    "DateTimeOriginal": "2023:06:20 13:21:41",
    "CreateDate": "2023:06:20 13:21:41",
    "ComponentsConfiguration": "Y, Cb, Cr, -",
    "ShutterSpeedValue": "1/197",
    "ApertureValue": 2.8,
    "Flash": "Off, Did not fire",
    "FocalLength": "50.0 mm",
    "MacroMode": "Normal",
    "SelfTimer": "Off",
    "Quality": "RAW",
    "CanonFlashMode": "Off",
    "ContinuousDrive": "Continuous, High",
    "FocusMode": "AI Servo AF",
    "RecordMode": "CR2",
    "CanonImageSize": "n/a",
    "EasyMode": "Manual",
    "DigitalZoom": "None",
    "Contrast": "Normal",
    "Saturation": "Normal",
    "MeteringMode": "Spot",
    "FocusRange": "Not Known",
    "CanonExposureMode": "Manual",
    "LensType": "Canon EF 50mm f/1.2L USM",
    "MaxFocalLength": "50 mm",
    "MinFocalLength": "50 mm",
    "FocalUnits": "1/mm",
    "MaxAperture": 1.3,
    "MinAperture": 16,
    "FlashActivity": 0,
    "FlashBits": "(none)",
    "ZoomSourceWidth": 0,
    "ZoomTargetWidth": 0,
    "ManualFlashOutput": "n/a",
    "ColorTone": "Normal",
    "SRAWQuality": "n/a",
    "AutoISO": 100,
    "BaseISO": 154,
    "MeasuredEV": 7,
    "TargetAperture": 2.8,
    "TargetExposureTime": "1/203",
    "ExposureCompensation": 0,
    "WhiteBalance": "Auto",
    "SlowShutter": "None",
    "SequenceNumber": 0,
    "OpticalZoomCode": "n/a",
    "CameraTemperature": "21 C",
    "FlashGuideNumber": 0,
    "FlashExposureComp": 0,
    "AutoExposureBracketing": "Off",
    "AEBBracketValue": 0,
    "ControlMode": "Camera Local Control",
    "MeasuredEV2": 8.625,
    "BulbDuration": 0,
    "CameraType": "EOS High-end",
    "NDFilter": "n/a",
    "CanonImageType": "Canon EOS 5D Mark IV",
    "CanonFirmwareVersion": "Firmware Version 1.0.1",
    "CanonModelID": "EOS 5D Mark IV",
    "ThumbnailImageValidArea": "0 159 7 112",
    "AFAreaMode": "Spot AF",
    "NumAFPoints": 63,
    "ValidAFPoints": 61,
    "CanonImageWidth": 6720,
    "CanonImageHeight": 4480,
    "AFImageWidth": 6720,
    "AFImageHeight": 4480,
    "AFAreaWidths": "218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 0 0",
    "AFAreaHeights": "218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 218 0 0",
    "AFAreaXPositions": "-336 -746 -1101 -1437 -1772 336 0 -336 -1437 -1772 1772 1437 1101 746 336 0 1437 1101 746 336 0 -336 -746 -1101 336 0 -336 -746 -1101 -1437 -1772 1772 -746 -1101 -1437 -1772 1772 1437 1101 746 -1772 1772 1437 1101 746 336 0 -336 1101 746 336 0 -336 -746 -1101 -1437 336 0 -336 1772 1437 0 0",
    "AFAreaYPositions": "547 625 625 625 625 821 821 821 308 308 625 625 625 625 547 547 308 308 308 274 274 274 308 308 0 0 0 0 0 0 0 308 -308 -308 -308 -308 0 0 0 0 -625 -308 -308 -308 -308 -274 -274 -274 -625 -625 -547 -547 -547 -625 -625 -625 -821 -821 -821 -625 -625 0 0",
    "AFPointsInFocus": 25,
    "AFPointsSelected": 25,
    "TimeZone": "-05:00",
    "TimeZoneCity": "New York",
    "DaylightSavings": "Off",
    "BatteryType": "LP-E6N",
    "BracketMode": "Off",
    "BracketValue": 0,
    "BracketShotNumber": 0,
    "RawJpgSize": "Large",
    "WBBracketMode": "Off",
    "WBBracketValueAB": 0,
    "WBBracketValueGM": 0,
    "LiveViewShooting": "Off",
    "FocusDistanceUpper": "1.52 m",
    "FocusDistanceLower": "1.39 m",
    "FlashExposureLock": "Off",
    "InternalSerialNumber": "",
    "DustRemovalData": "(Binary data 1024 bytes, use -b option to extract)",
    "CropLeftMargin": 0,
    "CropRightMargin": 0,
    "CropTopMargin": 0,
    "CropBottomMargin": 0,
    "ExposureLevelIncrements": "1/3 Stop",
    "ISOSpeedIncrements": "1/3 Stop",
    "AEBAutoCancel": "On",
    "AEBSequence": "0,-,+",
    "AEBShotCount": "3 shots",
    "SafetyShift": "Disable",
    "SameExposureForNewAperture": "Disable",
    "ShutterSpeedRange": "Disable; Hi 1/8192; Lo 32",
    "ApertureRange": "Enable; Closed 91; Open 1",
    "ViewfinderWarnings": "Monochrome, WB corrected, One-touch image quality, Noise reduction, HDR",
    "LVShootingAreaDisplay": "Masked",
    "CustomControls": "0 0 0 0 2 0 2 0 2 0 2 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 254 255 0 3 112 48 0 0 0 0 0 0 0 0 0 0 0 20 80 0 0 0 0 7 3 0 255 255 255 0 255 255 255",
    "DialDirectionTvAv": "Normal",
    "AddAspectRatioInfo": "Off",
    "DefaultEraseOption": "Cancel selected",
    "RetractLensOnPowerOff": "Enable",
    "AddIPTCInformation": "Disable",
    "AspectRatio": "3:2",
    "CroppedImageWidth": 6720,
    "CroppedImageHeight": 4480,
    "CroppedImageLeft": 0,
    "CroppedImageTop": 0,
    "ToneCurve": "Standard",
    "Sharpness": 3,
    "SharpnessFrequency": "n/a",
    "SensorRedLevel": 0,
    "SensorBlueLevel": 0,
    "WhiteBalanceRed": 0,
    "WhiteBalanceBlue": 0,
    "ColorTemperature": 4600,
    "PictureStyle": "Standard",
    "DigitalGain": 0,
    "WBShiftAB": 0,
    "WBShiftGM": 0,
    "MeasuredRGGB": "849 1024 1024 905",
    "VRDOffset": 0,
    "SensorWidth": 6880,
    "SensorHeight": 4544,
    "SensorLeftBorder": 148,
    "SensorTopBorder": 54,
    "SensorRightBorder": 6867,
    "SensorBottomBorder": 4533,
    "BlackMaskLeftBorder": 0,
    "BlackMaskTopBorder": 0,
    "BlackMaskRightBorder": 0,
    "BlackMaskBottomBorder": 0,
    "ColorDataVersion": "13 (80D)",
    "WB_RGGBLevelsAsShot": "1907 1024 1024 1496",
    "ColorTempAsShot": 4888,
    "WB_RGGBLevelsAuto": "1907 1024 1024 1496",
    "ColorTempAuto": 4888,
    "WB_RGGBLevelsMeasured": "1907 1024 1024 1496",
    "ColorTempMeasured": 4888,
    "WB_RGGBLevelsDaylight": "2028 1024 1024 1469",
    "ColorTempDaylight": 5200,
    "WB_RGGBLevelsShade": "2320 1024 1024 1274",
    "ColorTempShade": 7000,
    "WB_RGGBLevelsCloudy": "2171 1024 1024 1365",
    "ColorTempCloudy": 6000,
    "WB_RGGBLevelsTungsten": "1450 1024 1024 2064",
    "ColorTempTungsten": 3200,
    "WB_RGGBLevelsFluorescent": "1711 1024 1024 1990",
    "ColorTempFluorescent": 3634,
    "WB_RGGBLevelsKelvin": "1893 1024 1024 1589",
    "ColorTempKelvin": 4607,
    "WB_RGGBLevelsFlash": "2217 1024 1024 1362",
    "ColorTempFlash": 6156,
    "AverageBlackLevel": "512 512 512 512",
    "PerChannelBlackLevel": "512 511 512 511",
    "NormalWhiteLevel": 10422,
    "SpecularWhiteLevel": 10838,
    "LinearityUpperMargin": 10273,
    "PictureStyleUserDef": "Standard; Standard; Standard",
    "PictureStylePC": "None; None; None",
    "CustomPictureStyleFileName": "",
    "AFMicroAdjMode": "Disable",
    "AFMicroAdjValue": 0,
    "VignettingCorrVersion": 0,
    "PeripheralLighting": "Off",
    "DistortionCorrection": "Off",
    "ChromaticAberrationCorr": "Off",
    "PeripheralLightingValue": 0,
    "DistortionCorrectionValue": 0,
    "OriginalImageWidth": 0,
    "OriginalImageHeight": 1228,
    "PeripheralLightingSetting": "Off",
    "ChromaticAberrationSetting": "Off",
    "DistortionCorrectionSetting": "Off",
    "PeripheralIlluminationCorr": "On",
    "AutoLightingOptimizer": "Off",
    "HighlightTonePriority": "Off",
    "LongExposureNoiseReduction": "Off",
    "HighISONoiseReduction": "Off",
    "MultiExposure": "Off",
    "MultiExposureControl": "Additive",
    "MultiExposureShots": 0,
    "HDR": "Off",
    "HDREffect": "Natural",
    "AFConfigTool": "Case 1",
    "AFTrackingSensitivity": 0,
    "AFAccelDecelTracking": 0,
    "AFPointSwitching": 0,
    "AIServoFirstImage": "Equal Priority",
    "AIServoSecondImage": "Equal Priority",
    "USMLensElectronicMF": "Enable After AF",
    "AFAssistBeam": "Enable",
    "OneShotAFRelease": "Focus Priority",
    "LensDriveWhenAFImpossible": "Continue Focus Search",
    "SelectAFAreaSelectionMode": "Single-point AF, Auto, Zone AF, AF Point Expansion (4 point), Spot AF, AF Point Expansion (8 point), [6], [8], [9], [10], [11], [12], [13], [14]",
    "AFAreaSelectionMethod": "M-Fn Button",
    "OrientationLinkedAF": "Same for Vert/Horiz Points",
    "ManualAFPointSelPattern": "Stops at AF Area Edges",
    "AFPointDisplayDuringFocus": "All (constant)",
    "VFDisplayIllumination": "Auto",
    "UserComment": "",
    "SubSecTime": 63,
    "SubSecTimeOriginal": 63,
    "SubSecTimeDigitized": 63,
    "FlashpixVersion": "0100",
    "ColorSpace": "sRGB",
    "ExifImageWidth": 6720,
    "ExifImageHeight": 4480,
    "InteropIndex": "R98 - DCF basic file (sRGB)",
    "InteropVersion": "0100",
    "FocalPlaneXResolution": 5719.148936,
    "FocalPlaneYResolution": 5728.900256,
    "FocalPlaneResolutionUnit": "inches",
    "CustomRendered": "Normal",
    "ExposureMode": "Manual",
    "SceneCaptureType": "Standard",
    "OwnerName": "",
    "SerialNumber": "022021008250",
    "LensInfo": "50mm f/0",
    "LensModel": "EF50mm f/1.2L USM",
    "LensSerialNumber": "00008132e6",
    "GPSVersionID": "2.3.0.0",
    "ThumbnailOffset": 54792,
    "ThumbnailLength": 6818,
    "PhotometricInterpretation": "RGB",
    "SamplesPerPixel": 3,
    "RowsPerStrip": 284,
    "PlanarConfiguration": "Chunky",
    "StripOffsets": 1609384,
    "StripByteCounts": 26219388,
    "CR2CFAPattern": "[Red,Green][Green,Blue]",
    "RawImageSegmentation": "1 3440 3440",
    "SRawType": 1,
    "DriveMode": "Continuous Shooting",
    "Lens": "50.0 mm",
    "ShootingMode": "Manual",
    "WB_RGGBLevels": "1907 1024 1024 1496",
    "Aperture": 2.8,
    "BlueBalance": 1.460938,
    "ImageSize": "6720x4480",
    "LensID": "Canon EF 50mm f/1.2L USM",
    "Megapixels": 30.1,
    "PreviewImage": "(Binary data 815042 bytes, use -b option to extract)",
    "RedBalance": 1.862305,
    "ScaleFactor35efl": 1.2,
    "ShutterSpeed": "1/200",
    "SubSecCreateDate": "2023:06:20 13:21:41.63",
    "SubSecDateTimeOriginal": "2023:06:20 13:21:41.63",
    "SubSecModifyDate": "2023:06:20 13:21:41.63",
    "ThumbnailImage": "(Binary data 6818 bytes, use -b option to extract)",
    "Lens35efl": "50.0 mm (35 mm equivalent: 60.3 mm)",
    "CircleOfConfusion": "0.025 mm",
    "DOF": "0.11 m (1.40 - 1.51 m)",
    "FOV": "33.2 deg",
    "FocalLength35efl": "50.0 mm (35 mm equivalent: 60.3 mm)",
    "HyperfocalDistance": "35.86 m",
    "LightValue": 9.9
}

### iPhone Exif Data

{
    "SourceFile": "/Volumes/sdx.1000/_ingest/2023_06/20/20230620.0.1330_NAHSP.Storytelling.Workshop/5d.a.stills/IMG_5217.DNG",
    "ExifToolVersion": 12.3,
    "FileName": "IMG_5217.DNG",
    "Directory": "/Volumes/sdx.1000/_ingest/2023_06/20/20230620.0.1330_NAHSP.Storytelling.Workshop/5d.a.stills",
    "FileSize": "56 MiB",
    "FileModifyDate": "2023:07:14 15:06:34-04:00",
    "FileAccessDate": "2023:07:14 16:44:24-04:00",
    "FileInodeChangeDate": "2023:07:14 15:07:49-04:00",
    "FilePermissions": "-rw-r--r--",
    "FileType": "DNG",
    "FileTypeExtension": "dng",
    "MIMEType": "image/x-adobe-dng",
    "ExifByteOrder": "Big-endian (Motorola, MM)",
    "Make": "Apple",
    "Model": "iPhone 14 Pro",
    "PreviewImageStart": 3165992,
    "Orientation": "Horizontal (normal)",
    "RowsPerStrip": 6048,
    "PreviewImageLength": 7464382,
    "Software": "16.1.2",
    "ModifyDate": "2023:07:14 15:06:26",
    "SubfileType": "Full-resolution image",
    "ImageWidth": 8064,
    "ImageHeight": 6048,
    "BitsPerSample": "10 10 10",
    "Compression": "JPEG",
    "PhotometricInterpretation": "Linear Raw",
    "SamplesPerPixel": 3,
    "PlanarConfiguration": "Chunky",
    "TileWidth": 1008,
    "TileLength": 1008,
    "TileOffsets": "(Binary data 431 bytes, use -b option to extract)",
    "TileByteCounts": "(Binary data 352 bytes, use -b option to extract)",
    "LinearizationTable": "(Binary data 5438 bytes, use -b option to extract)",
    "BlackLevel": "0 0 0",
    "WhiteLevel": "65535 65535 65535",
    "NoiseProfile": "3e-05 3e-08",
    "DefaultBlackRender": "None",
    "ExposureTime": "1/36",
    "FNumber": 1.8,
    "ExposureProgram": "Program AE",
    "ISO": 800,
    "ExifVersion": "0232",
    "DateTimeOriginal": "2023:07:14 15:06:26",
    "CreateDate": "2023:07:14 15:06:26",
    "OffsetTime": "-04:00",
    "OffsetTimeOriginal": "-04:00",
    "OffsetTimeDigitized": "-04:00",
    "ShutterSpeedValue": "1/36",
    "ApertureValue": 1.8,
    "BrightnessValue": -1.320868836,
    "ExposureCompensation": 0,
    "MeteringMode": "Multi-segment",
    "Flash": "Off, Did not fire",
    "FocalLength": "6.9 mm",
    "SubjectArea": "4018 3011 4418 2649",
    "RunTimeFlags": "Valid",
    "RunTimeValue": "1009286754022208",
    "RunTimeScale": 1000000000,
    "RunTimeEpoch": 0,
    "AccelerationVector": "-0.01197946538 0.07478670038 -1.000619769",
    "Warning": "[minor] Bad format (16) for MakerNotes entry 14",
    "SubSecTimeOriginal": 850,
    "SubSecTimeDigitized": 850,
    "ExifImageWidth": 8064,
    "ExifImageHeight": 6048,
    "SensingMethod": "One-chip color area",
    "SceneType": "Directly photographed",
    "ExposureMode": "Auto",
    "WhiteBalance": "Auto",
    "FocalLengthIn35mmFormat": "24 mm",
    "LensInfo": "2.220000029-9mm f/1.779999971-2.8",
    "LensMake": "Apple",
    "LensModel": "iPhone 14 Pro back triple camera 6.86mm f/1.78",
    "GPSLatitudeRef": "North",
    "GPSLongitudeRef": "West",
    "GPSAltitudeRef": "Above Sea Level",
    "GPSSpeedRef": "km/h",
    "GPSSpeed": 0,
    "GPSImgDirectionRef": "True North",
    "GPSImgDirection": 257.4727021,
    "GPSDestBearingRef": "True North",
    "GPSDestBearing": 257.4727021,
    "GPSDateStamp": "2023:07:14",
    "GPSHPositioningError": "8.21597775 m",
    "DNGVersion": "1.6.0.0",
    "DNGBackwardVersion": "1.3.0.0",
    "UniqueCameraModel": "iPhone15,2 back camera",
    "ColorMatrix1": "1.290177584 -0.6245414019 -0.2525035441 -0.47181952 1.537214279 -0.04470928013 -0.04709417745 0.1507237405 0.6165214777",
    "ColorMatrix2": "0.9558454156 -0.3676984012 -0.1344799995 -0.4303893447 1.323391318 0.08365981281 -0.09998676926 0.2129978091 0.4523701966",
    "AnalogBalance": "2.213134766 1 1.984619141",
    "AsShotNeutral": "1 1 1",
    "BaselineExposure": 1.07302916,
    "BaselineSharpness": 1.5,
    "CalibrationIlluminant1": "Standard Light A",
    "CalibrationIlluminant2": "D65",
    "NoiseReductionApplied": 0.9499999881,
    "ProfileName": "Apple Embedded Color Profile",
    "ProfileToneCurve": "(large array of 514 float values)",
    "RunTimeSincePowerUp": "11 days 16:21:27",
    "Aperture": 1.8,
    "ImageSize": "8064x6048",
    "Megapixels": 48.8,
    "PreviewImage": "(Binary data 7464382 bytes, use -b option to extract)",
    "ScaleFactor35efl": 3.5,
    "ShutterSpeed": "1/36",
    "SubSecCreateDate": "2023:07:14 15:06:26.850-04:00",
    "SubSecDateTimeOriginal": "2023:07:14 15:06:26.850-04:00",
    "SubSecModifyDate": "2023:07:14 15:06:26-04:00",
    "GPSAltitude": "21.4 m Above Sea Level",
    "GPSLatitude": "42 deg 22' 36.95\" N",
    "GPSLongitude": "71 deg 9' 30.46\" W",
    "CircleOfConfusion": "0.009 mm",
    "FOV": "73.7 deg",
    "FocalLength35efl": "6.9 mm (35 mm equivalent: 24.0 mm)",
    "GPSPosition": "42 deg 22' 36.95\" N, 71 deg 9' 30.46\" W",
    "HyperfocalDistance": "3.08 m",
    "LightValue": 3.8,
    "LensID": "iPhone 14 Pro back triple camera 6.86mm f/1.78"
}