-
Notifications
You must be signed in to change notification settings - Fork 1.6k
/
exif_csv.py
127 lines (108 loc) · 6.92 KB
/
exif_csv.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
# Disclaimer: This script is for educational purposes only.
# Do not use against any photos that you don't own or have authorization to test.
#!/usr/bin/env python3
# Please note:
# This program is for .JPG and .TIFF format files. The program could be extended to support .HEIC, .PNG and other formats.
# Installation and usage instructions:
# 1. Install Pillow (Pillow will not work if you have PIL installed):
# python3 -m pip install --upgrade pip
# python3 -m pip install --upgrade Pillow
# 2. Add .jpg images downloaded from Flickr to subfolder ./images from where the script is stored.
# Try the following Flickr account: https://www.flickr.com/photos/194419969@N07/? (Please don't use other Flickr accounts).
# Note most social media sites strip exif data from uploaded photos.
import os
import csv
from PIL import Image
from PIL.ExifTags import GPSTAGS, TAGS
# Helper function
def create_google_maps_url(gps_coords):
# Exif data stores coordinates in degree/minutes/seconds format. To convert to decimal degrees.
# We extract the data from the dictionary we sent to this function for latitudinal data.
dec_deg_lat = convert_decimal_degrees(float(gps_coords["lat"][0]), float(gps_coords["lat"][1]), float(gps_coords["lat"][2]), gps_coords["lat_ref"])
# We extract the data from the dictionary we sent to this function for longitudinal data.
dec_deg_lon = convert_decimal_degrees(float(gps_coords["lon"][0]), float(gps_coords["lon"][1]), float(gps_coords["lon"][2]), gps_coords["lon_ref"])
# We return a search string which can be used in Google Maps
return f"https://maps.google.com/?q={dec_deg_lat},{dec_deg_lon}"
# Converting to decimal degrees for latitude and longitude is from degree/minutes/seconds format is the same for latitude and longitude. So we use DRY principles, and create a seperate function.
def convert_decimal_degrees(degree, minutes, seconds, direction):
decimal_degrees = degree + minutes / 60 + seconds / 3600
# A value of "S" for South or West will be multiplied by -1
if direction == "S" or direction == "W":
decimal_degrees *= -1
return decimal_degrees
# Print Logo
print("""
______ _ _ ______ _ _
| _ \ (_) | | | ___ \ | | | |
| | | |__ ___ ___ __| | | |_/ / ___ _ __ ___ | |__ __ _| |
| | | / _` \ \ / / |/ _` | | ___ \/ _ \| '_ ` _ \| '_ \ / _` | |
| |/ / (_| |\ V /| | (_| | | |_/ / (_) | | | | | | |_) | (_| | |
|___/ \__,_| \_/ |_|\__,_| \____/ \___/|_| |_| |_|_.__/ \__,_|_|
_______ _____________ _____ _____ _____ _
| ___\ \ / /_ _| ___| |_ _| _ || _ | |
| |__ \ V / | | | |_ | | | | | || | | | |
| __| / \ | | | _| | | | | | || | | | |
| |___/ /^\ \_| |_| | | | \ \_/ /\ \_/ / |____
\____/\/ \/\___/\_| \_/ \___/ \___/\_____/
""")
# Add files to the folder ./images
# We assign the cwd to a variable. We will refer to it to get the path to images.
cwd = os.getcwd()
# Change the current working directory to the one where you keep your images.
os.chdir(os.path.join(cwd, "images"))
# Get a list of all the files in the images directory.
files = os.listdir()
# Check if you have any files in the ./images folder.
if len(files) == 0:
print("You don't have have files in the ./images folder.")
exit()
# Loop through the files in the images directory.
# We open a csv file to write the data to it.
with open("../exif_data.csv", "a", newline="") as csv_file:
# We create a writer for the csv format.
writer = csv.writer(csv_file)
for file in files:
# We add try except black to handle when there are wrong file formats in the ./images folder.
try:
# Open the image file. We open the file in binary format for reading.
image = Image.open(file)
print(f"_______________________________________________________________{file}_______________________________________________________________")
# The ._getexif() method returns a dictionary. .items() method returns a list of all dictionary keys and values.
gps_coords = {}
writer.writerow(("Filename", file))
# We check if exif data are defined for the image.
if image._getexif() == None:
writer.writerow((file, "Contains no exif data."))
# If exif data are defined we can cycle through the tag, and value for the file.
else:
for tag, value in image._getexif().items():
# If you print the tag without running it through the TAGS.get() method you'll get numerical values for every tag. We want the tags in human-readable form.
# You can see the tags and the associated decimal number in the exif standard here: https://exiv2.org/tags.html
tag_name = TAGS.get(tag)
if tag_name == "GPSInfo":
for key, val in value.items():
# Write the GPS Data value for every key to the csv file.
writer.writerow((GPSTAGS.get(key), {val}))
# We add Latitude data to the gps_coord dictionary which we initialized in line 110.
if GPSTAGS.get(key) == "GPSLatitude":
gps_coords["lat"] = val
# We add Longitude data to the gps_coord dictionary which we initialized in line 110.
elif GPSTAGS.get(key) == "GPSLongitude":
gps_coords["lon"] = val
# We add Latitude reference data to the gps_coord dictionary which we initialized in line 110.
elif GPSTAGS.get(key) == "GPSLatitudeRef":
gps_coords["lat_ref"] = val
# We add Longitude reference data to the gps_coord dictionary which we initialized in line 110.
elif GPSTAGS.get(key) == "GPSLongitudeRef":
gps_coords["lon_ref"] = val
else:
# We write data not related to the GPSInfo to the csv file.
writer.writerow((tag_name, value))
# We print the longitudinal and latitudinal data which has been formatted for Google Maps. We only do so if the GPS Coordinates exists.
if gps_coords:
# We write the Google Maps Link to the csv file.
writer.writerow(("Google Maps Link",create_google_maps_url(gps_coords)))
# Change back to the original working directory.
except IOError:
print("File format not supported!")
os.chdir(cwd)