EXIF Photo Database

Exchangeable image file format (Exif) embeds information about the camera and GPS location in JPEG images. This is very convenient, as it tags when and where a photograph was taken, but can have security implications as it shows when and where you were.  If you are on vacation, you home might be empty and could be targeted for break in based on that information.  You should be careful about where you place timely personal information such as your location.  In 2007 insurgents in Iraq apparently used geo-tagged photos posted on the internet to attack and destroy helicopters on the flight line.

Setting up the phone.


Ways to open EXIF database

 

Pick directory: to cycle through directory and its subdirectories to see other photos

Open file: pick a single image

Make DB: Create database with the DB button.  This will work with all images in the directory and its subdirectories.

You can include or exclude images with no location data.  The could might not be turned on for the camera, the camera might not have GPS, and the GPS units might not have acquired satellite yet.

Close: form closes

 

DB created:

  • Critical fields are LAT,LONG, and IMAGE.
  • ALTITUDE will be most useful for images from a drone or aircraft.
  • AZIMUTH is helpful to know when the photograph is looking, but will not always be present.  The azimith must be recorded in an expected format, which varies by camera.
  • IMAGE has the full path and file name.  To move to another computer, Edit:, String field operations, and Extract file name will remove the path, but then you have to insure the database and the images stay together, and you do not have imagery in subdirectories.
     

Cameras

https://en.wikipedia.org/wiki/Image_sensor_format


Last revision 12/16/20176