Image metadata

[AndyBiggs]

Hi all,

First post - great to see an online community building up behind a superb offline group of users.

I'm trying to work with a series of images, which all have metadata embedded (predominently want the lat, long, to do some geo spatial work) - anyone got any ideas how I can pull that metadata off the images?

Cheers,

Andy

[danielbrun2]

Hi Andy,

Not at my laptop = not tested.There is a directory input tool, but I can't remember how much detail it gives back.

Let me know if it helps.

Daniel

[AndyBiggs]

Hi Daniel,

Good thought - I'd been trying to open the image rather than targeting the directory.

Unfortunately, while there is some customisation on that tool, it's fairly limited and doesn't allow you to acces custom metadata.

Cheers,

Andy

[chris_love]

Hi Andy

What about using a cmdline tool like
http://www.sno.phy.queensu.ca/~phil/exiftool/ to automate this via the Run
Command Tool

Chris

[danielbrun2]

Not really Alteryx, but this could maybe help you retrieve your data for analysis.

http://blogs.technet.com/b/heyscriptingguy/archive/2014/02/05/list-music-file-metadata-in-a-csv-and-...

Best regards,

Daniel

[AdamR_AYX]

Hi Andy,

Are you able to share a sample image I can test my solution on?

[danielbrun2]

I am eager to see a solution. Perhaps you can use the attached picture? (I am not sure if it looses it metadata when uploaded as a picture, but jpeg is not an allowed file upload format.)

Daniel

[anthony]

Here is the exif data via a online service - i searched jpg file with VIM and could not see any of those words so it must be part of the JPEG compression - you will need to find a way to uncompress more than likely.  Or a online service to dump data to a flat file.

[GarthM]

I imagine you could use the R package 'adimpro' to achieve this goal; however, you'll need to install additional tools to get the most out of it (dcraw & ImageMagik). This is the extent of what I can offer since my experience with adimpro is equal to the searching of the google's I did this morning.

[AdamR_AYX · Accepted solution]

Here is my EXIF Reader Alteryx macro!

The values I am getting out look to be the same as that online tool.

It is using a command line tool http://www.sno.phy.queensu.ca/~phil/exiftool/ to extract the information.  Many thanks go to Phil Harvey for writing that tool as that is what is doing the bulk of the work here.