Skip to content

Instantly share code, notes, and snippets.

@rjp
Created November 9, 2009 13:02
Show Gist options
  • Save rjp/229928 to your computer and use it in GitHub Desktop.
Save rjp/229928 to your computer and use it in GitHub Desktop.
sqlite> select * from exif where id=4004581772 limit 20;
4004581772|AFPoint Selected||Auto|
4004581772|AFPoints In Focus||Center|
4004581772|Aperture|f/5.0|5.0|f/5.0
4004581772|Auto Bracketing||0|
4004581772|Bits Per Sample||8|
4004581772|Blue Balance||1.0546875|
4004581772|Camera Temperature||19 C|
4004581772|CircleOfConfusion||0.005 mm|
4004581772|Color Components||3|
4004581772|Color Space||sRGB|
4004581772|ComponentsConfiguration||YCbCr|
4004581772|Compressed Bits Per Pixel||3.373555501|
4004581772|Compression||JPEG (old-style)|
4004581772|Contrast||Normal|
4004581772|Custom Rendered||Normal|
4004581772|DSPFirmware Version||1.00.00.00|
4004581772|Date||2009:10:10|
4004581772|Date and Time (Digitized)||2009:10:10 04:34:10|
4004581772|Date and Time (Modified)||2009:10:10 04:34:10|
4004581772|Date and Time (Original)||2009:10:10 04:34:10|
4004581772|Destination City||London|
4004581772|Destination DST||No|
4004581772|Digital Zoom||0|
4004581772|Digital Zoom Ratio||0|
4004581772|Effective LV||12.3|
4004581772|Encoding Process||Baseline DCT, Huffman coding|
4004581772|ExifImageHeight||1536|
4004581772|ExifImageWidth||2048|
4004581772|ExifVersion||0220|
4004581772|Exposure|0.006 sec (1/160)|1/160|0.006 sec (1/160)
4004581772|Exposure Bias|0 EV|0|0 EV
4004581772|Exposure Compensation||0|
4004581772|Exposure Mode||Auto|
4004581772|Exposure Program||Program AE|
4004581772|Exposure Time||1/160|
4004581772|FNumber||5.0|
4004581772|FOV||34.5 deg|
4004581772|File Size||1353 kB|
4004581772|File Type||JPEG|
4004581772|Flash||Off, Did not fire|
4004581772|FlashpixVersion||0100|
4004581772|Focal Length||9.5 mm|
4004581772|Focal Length In35mm Format||58 mm|
4004581772|FocalLength35efl||9.5 mm (35 mm equivalent: 58.0 mm)|
4004581772|Focus Mode||Normal|
4004581772|Focus Position||7|
4004581772|Frame Number||3896|
4004581772|Hometown City||London|
4004581772|Hometown DST||No|
4004581772|HyperfocalDistance||3.67 m|
4004581772|ISO||50|
4004581772|ISO Speed||50|
4004581772|Image Height||1536|
4004581772|Image Processing||Unprocessed|
4004581772|Image Processing Count||0|
4004581772|Image Width||2048|
4004581772|ImageSize||2048x1536|
4004581772|Internal Serial Number||2505|
4004581772|InteropIndex||R98 - DCF basic file (sRGB)|
4004581772|InteropVersion||0100|
4004581772|Light Reading||220|
4004581772|LightValue||13.0|
4004581772|MIME Type||image/jpeg|
4004581772|Make||PENTAX Corporation|
4004581772|Manufacture Date||Unknown (0)|
4004581772|Max Aperture Value||2.8|
4004581772|Metering Mode||Multi-segment|
4004581772|Model||PENTAX Optio SVi|
4004581772|Noise Reduction||Off|
4004581772|Orientation||Horizontal (normal)|
4004581772|Pentax Image Size||2048x1536|
4004581772|Pentax Model ID||Optio SVi|
4004581772|Pentax Model Type||0|
4004581772|Picture Mode||Program|
4004581772|Preview Image Length||26428|
4004581772|Preview Image Size||320x240|
4004581772|Preview Image Start||1872|
4004581772|PreviewImage||(Binary data 26428 bytes, use -b option to extract)|
4004581772|Production Code||1.1|
4004581772|Quality||Best|
4004581772|Red Balance||1.05078125|
4004581772|ResolutionUnit||inches|
4004581772|Saturation||Normal|
4004581772|ScaleFactor35efl||6.1|
4004581772|Scene Capture Type||Standard|
4004581772|Sharpness||Normal|
4004581772|ShutterSpeed||1/160|
4004581772|Software||Optio SVi Ver 1.00 |
4004581772|Subject Distance Range||Distant|
4004581772|ThumbnailLength||8463|
4004581772|ThumbnailOffset||50352|
4004581772|Time||04:34:10|
4004581772|White Balance||Auto|
4004581772|White Balance Mode||Auto (Daylight)|
4004581772|World Time Location||Hometown|
4004581772|X-Resolution|72 dpi|72|72 dpi
4004581772|XResolution||72|
4004581772|Y-Resolution|72 dpi|72|72 dpi
4004581772|YCbCr Positioning||Co-sited|
4004581772|YCbCrSubSampling||YCbCr4:2:0 (2 2)|
4004581772|YResolution||72|
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment