---
tags: airtable, planning, media
---
# media admin check in 20230713
## avBase hopes and dreams
*what's working well? what would you like to work better? what's confusing? what would be amazing to have?*
[current avBase](https://airtable.com/app5m3BQKht50HnWE/tblyd4WIc2cP6eg9L/viwLP8GES2vHBQQ2p?blocks=hide)
- table for individual video clips
- with fields for data from ffprobe, linked to shoot record
- https://airtable.com/shrx2mvwpOSaWwYes
- table for individual stills
- with fields for exif data from exiftool, linked to shoot record
- innovation in all day capture
- try to capture which drives are being used and what's recorded on them. having that data by the time the ingest script gets done. would love for that to already be at sophie's fingertips
- binder clips printed by MW?
- overlaps with "Events" base
- ~~scripts that compare file checksum between synologies~~
- would like updated proxy for everything we've done and everything we ever do, and for this to be a little easier
- other things to add
- ~~autostills (to slack)~~
- selected or emojied autostills
- hero shots (human selected) for each shoot
- Do we need a separate media-production-base? or can this just live in the AVBase?
- the separate media production base might involve kanbans that track the process of editing from rough cuts to client feedback to revised cuts to finishing (color and audio) through to delivery, for instance, including any automations that help this
- but the delivered videos need to hit the AVBase
- casey would like:
- ways to track xmls
- whose been editing
- where it is in the edit
- mk excited to help with workflows for mpas! we'll loop in jordan for things llufs may help with
- extra stills we may want
- we'll want workflows for both final cut and resolve (tbd on premiere)
## workflow things
for both shoots and live events
as well as editing
editing stack:
- need to haves (full time staff)
- lean on scripting and automations
- nice to haves (MPAs, llufs)
- add here
### workflow questions
* where should we track files
* where should we track media work
* how does this relate to project tracking and task tracking
### shoots and live events
- let's come up with something like a manual in this space
- list of what we want the mpas to get trained to do
- prep studio (and know how early to start this)
- formatted cards/drives in recorders/cameras
- correct initial shots lined up in every camera and selected on correct MEs
- set up PA?
- start shoot
- set mic placement and monitor
- hit record on everything and make sure it's recording throughout the shoot
- while shoot is happening
- if activity shifts out of camera's view, reframe
- if you have extra time and there's the option of capturing good b-roll with a 70-200, say, try to do this is the dead time
- live stills
- monitor audio
- antipate need for new camera positions or audio recording locations
- operate switcher if needed
-
- and the events that are coming up where they can practice
-
### editing
## mpa training
## messy notes
* august 14th as a deadline to have our plan together. but can still continue to build things out between then and the start of the new year (classes start sept5)
* we should be on the new capture method by august 14
* mpas - we want to rely on them for live event and shoot support
* mk would like to go back in time and normalize old shoot data (not renaming though)
* things that are 'nice to have' (like maybe backdata and updated proxy) are good for MPAs when we don't have more pressing things to do
## to do -
* design and launch the videofiles and stills tables
* run off sample JSON and paste in hackMD or print and meet on zoom or debate collectively via hackMD about fields
* to decide on canonical names for fields and types of fields for the fields
* let's track the amount of time experimental summer work is taking, and then mk will work with everyone to figure out the workflow/plan
## FFMPEG JSON(Hyperdeck)
```
[
{
"streams": [
{
"index": 0,
"codec_name": "h264",
"codec_long_name": "H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10",
"profile": "High 4:2:2",
"codec_type": "video",
"codec_tag_string": "avc1",
"codec_tag": "0x31637661",
"width": 1920,
"height": 1080,
"coded_width": 1920,
"coded_height": 1080,
"closed_captions": 0,
"film_grain": 0,
"has_b_frames": 0,
"sample_aspect_ratio": "1:1",
"display_aspect_ratio": "16:9",
"pix_fmt": "yuv422p10le",
"level": 41,
"color_range": "tv",
"color_space": "bt2020nc",
"color_transfer": "bt709",
"color_primaries": "bt2020",
"field_order": "progressive",
"refs": 1,
"is_avc": "true",
"nal_length_size": "4",
"id": "0x1",
"r_frame_rate": "24/1",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85248,
"duration": "3552.000000",
"bit_rate": "10085621",
"bits_per_raw_sample": "10",
"nb_frames": "85248",
"extradata_size": 31,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T10:05:29.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Video Media Handler",
"vendor_id": "BMAG",
"encoder": "H264/AVC",
"timecode": "10:42:46:17"
}
},
{
"index": 1,
"codec_type": "data",
"codec_tag_string": "tmcd",
"codec_tag": "0x64636d74",
"id": "0x2",
"r_frame_rate": "0/0",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85248,
"duration": "3552.000000",
"nb_frames": "1",
"extradata_size": 18,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T10:05:29.000000Z",
"language": "eng",
"handler_name": "\u0017Time Code Media Handler",
"timecode": "10:42:46:17"
}
},
{
"index": 2,
"codec_name": "aac",
"codec_long_name": "AAC (Advanced Audio Coding)",
"profile": "LC",
"codec_type": "audio",
"codec_tag_string": "mp4a",
"codec_tag": "0x6134706d",
"sample_fmt": "fltp",
"sample_rate": "48000",
"channels": 2,
"channel_layout": "stereo",
"bits_per_sample": 0,
"id": "0x3",
"r_frame_rate": "0/0",
"avg_frame_rate": "0/0",
"time_base": "1/48000",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 170496000,
"duration": "3552.000000",
"bit_rate": "128001",
"nb_frames": "166502",
"extradata_size": 2,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T10:05:29.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Sound Media Handler",
"vendor_id": "[0][0][0][0]",
"timecode": "10:42:46:17"
}
}
],
"format": {
"filename": "/Volumes/sdx.1000/_ingest/2023_06/21/20230621.0.1103_LLSUMMEROFAI.Content.Recording/hyper.a.h264/20230621.0.1103_LLSUMMEROFAI.Content.Recording_hyper.a.h264.0001.mp4",
"nb_streams": 3,
"nb_programs": 0,
"format_name": "mov,mp4,m4a,3gp,3g2,mj2",
"format_long_name": "QuickTime / MOV",
"start_time": "0.000000",
"duration": "3552.000000",
"size": "4536594392",
"bit_rate": "10217554",
"probe_score": 100,
"tags": {
"major_brand": "isom",
"minor_version": "1",
"compatible_brands": "iso4avc1isom",
"creation_time": "2023-06-21T10:05:29.000000Z",
"com.apple.proapps.reel": "1",
"com.apple.proapps.scene": "1",
"com.apple.proapps.shot": "99",
"com.blackmagic-design.camera.environment": "interior",
"com.blackmagic-design.camera.dayNight": "day",
"com.apple.proapps.cameraName": "A",
"com.blackmagic-design.camera.dateRecorded": "20230621"
}
}
},
{
"streams": [
{
"index": 0,
"codec_name": "h264",
"codec_long_name": "H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10",
"profile": "High 4:2:2",
"codec_type": "video",
"codec_tag_string": "avc1",
"codec_tag": "0x31637661",
"width": 1920,
"height": 1080,
"coded_width": 1920,
"coded_height": 1080,
"closed_captions": 0,
"film_grain": 0,
"has_b_frames": 0,
"sample_aspect_ratio": "1:1",
"display_aspect_ratio": "16:9",
"pix_fmt": "yuv422p10le",
"level": 41,
"color_range": "tv",
"color_space": "bt2020nc",
"color_transfer": "bt709",
"color_primaries": "bt2020",
"field_order": "progressive",
"refs": 1,
"is_avc": "true",
"nal_length_size": "4",
"id": "0x1",
"r_frame_rate": "24/1",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85320,
"duration": "3555.000000",
"bit_rate": "34373061",
"bits_per_raw_sample": "10",
"nb_frames": "85320",
"extradata_size": 31,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:03:42.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Video Media Handler",
"vendor_id": "BMAG",
"encoder": "H264/AVC",
"timecode": "10:42:46:01"
}
},
{
"index": 1,
"codec_type": "data",
"codec_tag_string": "tmcd",
"codec_tag": "0x64636d74",
"id": "0x2",
"r_frame_rate": "0/0",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85320,
"duration": "3555.000000",
"nb_frames": "1",
"extradata_size": 18,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:03:42.000000Z",
"language": "eng",
"handler_name": "\u0017Time Code Media Handler",
"timecode": "10:42:46:01"
}
},
{
"index": 2,
"codec_name": "aac",
"codec_long_name": "AAC (Advanced Audio Coding)",
"profile": "LC",
"codec_type": "audio",
"codec_tag_string": "mp4a",
"codec_tag": "0x6134706d",
"sample_fmt": "fltp",
"sample_rate": "48000",
"channels": 2,
"channel_layout": "stereo",
"bits_per_sample": 0,
"id": "0x3",
"r_frame_rate": "0/0",
"avg_frame_rate": "0/0",
"time_base": "1/48000",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 170640000,
"duration": "3555.000000",
"bit_rate": "128001",
"nb_frames": "166643",
"extradata_size": 2,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:03:42.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Sound Media Handler",
"vendor_id": "[0][0][0][0]",
"timecode": "10:42:46:01"
}
}
],
"format": {
"filename": "/Volumes/sdx.1000/_ingest/2023_06/21/20230621.0.1103_LLSUMMEROFAI.Content.Recording/hyper.b.h264/20230621.0.1103_LLSUMMEROFAI.Content.Recording_hyper.b.h264.0001.mp4",
"nb_streams": 3,
"nb_programs": 0,
"format_name": "mov,mp4,m4a,3gp,3g2,mj2",
"format_long_name": "QuickTime / MOV",
"start_time": "0.000000",
"duration": "3555.000000",
"size": "15333156240",
"bit_rate": "34504992",
"probe_score": 100,
"tags": {
"major_brand": "isom",
"minor_version": "1",
"compatible_brands": "iso4avc1isom",
"creation_time": "2023-06-21T15:03:42.000000Z",
"com.apple.proapps.reel": "1",
"com.apple.proapps.scene": "1",
"com.apple.proapps.shot": "83",
"com.blackmagic-design.camera.environment": "interior",
"com.blackmagic-design.camera.dayNight": "day",
"com.apple.proapps.cameraName": "A",
"com.blackmagic-design.camera.dateRecorded": "20230621"
}
}
},
{
"streams": [
{
"index": 0,
"codec_name": "h264",
"codec_long_name": "H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10",
"profile": "High 4:2:2",
"codec_type": "video",
"codec_tag_string": "avc1",
"codec_tag": "0x31637661",
"width": 1920,
"height": 1080,
"coded_width": 1920,
"coded_height": 1080,
"closed_captions": 0,
"film_grain": 0,
"has_b_frames": 0,
"sample_aspect_ratio": "1:1",
"display_aspect_ratio": "16:9",
"pix_fmt": "yuv422p10le",
"level": 41,
"color_range": "tv",
"color_space": "bt2020nc",
"color_transfer": "bt709",
"color_primaries": "bt2020",
"field_order": "progressive",
"refs": 1,
"is_avc": "true",
"nal_length_size": "4",
"id": "0x1",
"r_frame_rate": "24/1",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85320,
"duration": "3555.000000",
"bit_rate": "13491788",
"bits_per_raw_sample": "10",
"nb_frames": "85320",
"extradata_size": 31,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:03:36.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Video Media Handler",
"vendor_id": "BMAG",
"encoder": "H264/AVC",
"timecode": "10:42:45:17"
}
},
{
"index": 1,
"codec_type": "data",
"codec_tag_string": "tmcd",
"codec_tag": "0x64636d74",
"id": "0x2",
"r_frame_rate": "0/0",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85320,
"duration": "3555.000000",
"nb_frames": "1",
"extradata_size": 18,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:03:36.000000Z",
"language": "eng",
"handler_name": "\u0017Time Code Media Handler",
"timecode": "10:42:45:17"
}
},
{
"index": 2,
"codec_name": "aac",
"codec_long_name": "AAC (Advanced Audio Coding)",
"profile": "LC",
"codec_type": "audio",
"codec_tag_string": "mp4a",
"codec_tag": "0x6134706d",
"sample_fmt": "fltp",
"sample_rate": "48000",
"channels": 2,
"channel_layout": "stereo",
"bits_per_sample": 0,
"id": "0x3",
"r_frame_rate": "0/0",
"avg_frame_rate": "0/0",
"time_base": "1/48000",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 170640000,
"duration": "3555.000000",
"bit_rate": "128001",
"nb_frames": "166643",
"extradata_size": 2,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:03:36.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Sound Media Handler",
"vendor_id": "[0][0][0][0]",
"timecode": "10:42:45:17"
}
}
],
"format": {
"filename": "/Volumes/sdx.1000/_ingest/2023_06/21/20230621.0.1103_LLSUMMEROFAI.Content.Recording/hyper.c.h264/20230621.0.1103_LLSUMMEROFAI.Content.Recording_hyper.c.h264.0001.mp4",
"nb_streams": 3,
"nb_programs": 0,
"format_name": "mov,mp4,m4a,3gp,3g2,mj2",
"format_long_name": "QuickTime / MOV",
"start_time": "0.000000",
"duration": "3555.000000",
"size": "6054040976",
"bit_rate": "13623720",
"probe_score": 100,
"tags": {
"major_brand": "isom",
"minor_version": "1",
"compatible_brands": "iso4avc1isom",
"creation_time": "2023-06-21T15:03:36.000000Z",
"com.apple.proapps.reel": "1",
"com.apple.proapps.scene": "1",
"com.apple.proapps.shot": "62",
"com.blackmagic-design.camera.environment": "interior",
"com.blackmagic-design.camera.dayNight": "day",
"com.apple.proapps.cameraName": "A",
"com.blackmagic-design.camera.dateRecorded": "20230621"
}
}
},
{
"streams": [
{
"index": 0,
"codec_name": "h264",
"codec_long_name": "H.264 / AVC / MPEG-4 AVC / MPEG-4 part 10",
"profile": "High 4:2:2",
"codec_type": "video",
"codec_tag_string": "avc1",
"codec_tag": "0x31637661",
"width": 1920,
"height": 1080,
"coded_width": 1920,
"coded_height": 1080,
"closed_captions": 0,
"film_grain": 0,
"has_b_frames": 0,
"sample_aspect_ratio": "1:1",
"display_aspect_ratio": "16:9",
"pix_fmt": "yuv422p10le",
"level": 41,
"color_range": "tv",
"color_space": "bt2020nc",
"color_transfer": "bt709",
"color_primaries": "bt2020",
"field_order": "progressive",
"refs": 1,
"is_avc": "true",
"nal_length_size": "4",
"id": "0x1",
"r_frame_rate": "24/1",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85272,
"duration": "3553.000000",
"bit_rate": "35753867",
"bits_per_raw_sample": "10",
"nb_frames": "85272",
"extradata_size": 31,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:08:33.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Video Media Handler",
"vendor_id": "BMAG",
"encoder": "H264/AVC",
"timecode": "10:42:46:08"
}
},
{
"index": 1,
"codec_type": "data",
"codec_tag_string": "tmcd",
"codec_tag": "0x64636d74",
"id": "0x2",
"r_frame_rate": "0/0",
"avg_frame_rate": "24/1",
"time_base": "1/24",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 85272,
"duration": "3553.000000",
"nb_frames": "1",
"extradata_size": 18,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:08:33.000000Z",
"language": "eng",
"handler_name": "\u0017Time Code Media Handler",
"timecode": "10:42:46:08"
}
},
{
"index": 2,
"codec_name": "aac",
"codec_long_name": "AAC (Advanced Audio Coding)",
"profile": "LC",
"codec_type": "audio",
"codec_tag_string": "mp4a",
"codec_tag": "0x6134706d",
"sample_fmt": "fltp",
"sample_rate": "48000",
"channels": 2,
"channel_layout": "stereo",
"bits_per_sample": 0,
"id": "0x3",
"r_frame_rate": "0/0",
"avg_frame_rate": "0/0",
"time_base": "1/48000",
"start_pts": 0,
"start_time": "0.000000",
"duration_ts": 170544000,
"duration": "3553.000000",
"bit_rate": "128001",
"nb_frames": "166549",
"extradata_size": 2,
"disposition": {
"default": 1,
"dub": 0,
"original": 0,
"comment": 0,
"lyrics": 0,
"karaoke": 0,
"forced": 0,
"hearing_impaired": 0,
"visual_impaired": 0,
"clean_effects": 0,
"attached_pic": 0,
"timed_thumbnails": 0,
"captions": 0,
"descriptions": 0,
"metadata": 0,
"dependent": 0,
"still_image": 0
},
"tags": {
"creation_time": "2023-06-21T15:08:33.000000Z",
"language": "eng",
"handler_name": "\u0019Apple Sound Media Handler",
"vendor_id": "[0][0][0][0]",
"timecode": "10:42:46:08"
}
}
],
"format": {
"filename": "/Volumes/sdx.1000/_ingest/2023_06/21/20230621.0.1103_LLSUMMEROFAI.Content.Recording/hyper.d.h264/20230621.0.1103_LLSUMMEROFAI.Content.Recording_hyper.d.h264.0001.mp4",
"nb_streams": 3,
"nb_programs": 0,
"format_name": "mov,mp4,m4a,3gp,3g2,mj2",
"format_long_name": "QuickTime / MOV",
"start_time": "0.000000",
"duration": "3553.000000",
"size": "15937778112",
"bit_rate": "35885793",
"probe_score": 100,
"tags": {
"major_brand": "isom",
"minor_version": "1",
"compatible_brands": "iso4avc1isom",
"creation_time": "2023-06-21T15:08:33.000000Z",
"com.apple.proapps.reel": "1",
"com.apple.proapps.scene": "1",
"com.apple.proapps.shot": "98",
"com.blackmagic-design.camera.environment": "interior",
"com.blackmagic-design.camera.dayNight": "day",
"com.apple.proapps.cameraName": "A",
"com.blackmagic-design.camera.dateRecorded": "20230621"
}
}
}
]
```
____________________________________________________
## CR2 Exif
```
[
{
"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.0001.CR2",
"ExifTool": {
"ExifToolVersion": 12.3
},
"File": {
"FileName": "20230620.0.1330_NAHSP.Storytelling.Workshop_5d.a.stills.0001.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:42-04:00",
"FileAccessDate": "2023:07:14 14:26:54-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)"
},
"EXIF": {
"ImageWidth": 6720,
"ImageHeight": 4480,
"BitsPerSample": "8 8 8",
"Compression": "JPEG (old-style)",
"Make": "Canon",
"Model": "Canon EOS 5D Mark IV",
"PreviewImageStart": 61288,
"Orientation": "Horizontal (normal)",
"PreviewImageLength": 825491,
"XResolution": 72,
"YResolution": 72,
"ResolutionUnit": "inches",
"ModifyDate": "2023:06:20 13:21:41",
"Artist": "",
"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,
"ExposureCompensation": 0,
"MeteringMode": "Spot",
"Flash": "Off, Did not fire",
"FocalLength": "50.0 mm",
"UserComment": "",
"SubSecTime": 34,
"SubSecTimeOriginal": 34,
"SubSecTimeDigitized": 34,
"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",
"WhiteBalance": "Auto",
"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": 6494,
"PhotometricInterpretation": "RGB",
"SamplesPerPixel": 3,
"RowsPerStrip": 284,
"PlanarConfiguration": "Chunky",
"StripOffsets": 1619504,
"StripByteCounts": 26593468,
"CR2CFAPattern": "[Red,Green][Green,Blue]",
"RawImageSegmentation": "1 3440 3440",
"SRawType": 1,
"PreviewImage": "(Binary data 825491 bytes, use -b option to extract)",
"ThumbnailImage": "(Binary data 6494 bytes, use -b option to extract)"
},
"XMP": {
"Rating": 0
},
"MakerNotes": {
"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",
"FocalLength": "50 mm",
"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",
"FNumber": 2.8,
"ExposureTime": "1/203",
"MeasuredEV2": 8.625,
"BulbDuration": 0,
"CameraType": "EOS High-end",
"NDFilter": "n/a",
"CanonImageType": "Canon EOS 5D Mark IV",
"CanonFirmwareVersion": "Firmware Version 1.0.1",
"OwnerName": "",
"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.39 m",
"FocusDistanceLower": "1.28 m",
"FlashExposureLock": "Off",
"LensModel": "EF50mm f/1.2L USM",
"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": "881 1024 1024 906",
"ColorSpace": "sRGB",
"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 512 512 512",
"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",
"LensSerialNumber": "00008132e6",
"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"
},
"Composite": {
"DriveMode": "Continuous Shooting",
"ISO": 154,
"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,
"RedBalance": 1.862305,
"ScaleFactor35efl": 1.2,
"ShutterSpeed": "1/200",
"SubSecCreateDate": "2023:06:20 13:21:41.34",
"SubSecDateTimeOriginal": "2023:06:20 13:21:41.34",
"SubSecModifyDate": "2023:06:20 13:21:41.34",
"Lens35efl": "50.0 mm (35 mm equivalent: 60.3 mm)",
"CircleOfConfusion": "0.025 mm",
"DOF": "0.10 m (1.29 - 1.38 m)",
"FOV": "33.2 deg",
"FocalLength35efl": "50.0 mm (35 mm equivalent: 60.3 mm)",
"HyperfocalDistance": "35.86 m",
"LightValue": 9.9
}
}
]
```
_______________________________________
## iPhone Exif
```
[
{
"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 15:15:20-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"
}
]
```
Sign in with Wallet
Connect another wallet