{"id":320,"date":"2012-11-08T07:16:00","date_gmt":"2012-11-08T07:16:00","guid":{"rendered":"http:\/\/dbbd.sg\/blog\/uncategorized\/geocoding-from-the-streets-to-adobe-bridge-and-then-excel-part-i\/"},"modified":"2022-03-09T07:35:30","modified_gmt":"2022-03-09T07:35:30","slug":"geocoding-from-the-streets-to-adobe-bridge-and-then-excel-part-i","status":"publish","type":"post","link":"https:\/\/dbbd.sg\/blog\/2012\/11\/geocoding-from-the-streets-to-adobe-bridge-and-then-excel-part-i\/","title":{"rendered":"Geocoding: From the streets to Adobe Bridge and then Excel (Part I)"},"content":{"rendered":"

This is a documentation post for my own record on how I will produce a map of 180 date points that I have collected so far. To be honest I’m not a real programmer or anything like that, so the methods used in this post might be desultory or silly. I’m helplessly flapping about here. I’d be happy to hear of what method others would use! But in the absence of any external assistance……..<\/p>\n

So the situation thus far is that all the images I have taken have been geotagged by default in iPhone 4, and I want to pull the metadata out into csv (comma separated values) and then bring into something like TileMill where I can produce a proper map of it all.<\/p>\n

\"Screen<\/center>Viewing Metadata in Adobe Bridge
\nBut first, the drudgery. I needed to batch export the filenames and gps data from all my images. Unfortunately there was no instant readymade solution for this online that I could immediately find. Like with Illustrator and Flash’s automation scripts, what I ended having to do was to write a simple Adobe Bridge script to export all the information…<\/p>\n

To find the location for your Bridge scripts, go to Preferences > Click on “Reveal My Startup Scripts” to see the folder in Finder. I found a script on a forum<\/a> and adapted it slightly (quick and dirty) to include the GPS data. Save it as a .jsx file and drop it into the Startup Scripts folder. Because Bridge is silly, you will have to close and reopen Bridge in order for the script to load – apparently you can’t load it on the fly while Bridge is open. With this script, a new menu item will appear under tools: “Export CSV file<\/b>”<\/p>\n

\"Screen<\/center>Export to CSV
\nFor some reason, iPhone’s geodata is formatted in degrees:minutes:seconds rather than decimal degrees, and on top of that – confusingly \u00ba (degree) is replaced by comma and minutes by full stop, e.g:<\/p>\n

48,49.8N 2,22.13E<\/b><\/p>\n

I wonder why that is so by default. I suppose I understand it but let me tell you if you just plug this into TileMill it wont be read because of the wrong delimiters and I suspect it also requires decimal degrees (DD) instead of degrees-minutes-seconds (DMS). Cue the furious googling of “HOW DOES I CONVERT DMS TO DD?”<\/p>\n

Anyway back to the batch exporting of metadata to Excel. The data is saved in different namespaces such as the “exif” and “photoshop” data. EXIF stands for Exchangeable image file format and this is the format for the storage of metadata in files such as images and also audio files. You need to invoke the right namespace to find the right property. For example I realised that the Date Created in both exif and photoshop are different because only files that have been edited within photoshop have got a Date Created stamp (do note the property names also differ slightly in syntax although they may describe similar types of properties).<\/p>\n

I eventually figured out which namespace the gps data resided in (EXIF). I don’t know why it isn’t more straightforward to find a reference for all these things. Anyway since we are on the topic, this is a list of standard Namespaces; from these different namespaces you can search for the properties you are looking for so you can call them up:<\/p>\n

IPTC Core: http:\/\/iptc.org\/std\/Iptc4xmpCore\/1.0\/xmlns\/ (“Iptc4xmpCore”)
\nEXIF: http:\/\/ns.adobe.com\/exif\/1.0\/ (“exif”);
\nDublin Core: http:\/\/purl.org\/dc\/elements\/1.1\/ (“dc”)
\nTIFF: http:\/\/ns.adobe.com\/tiff\/1.0\/ (“tiff”)
\nXMP Basic: http:\/\/ns.adobe.com\/xap\/1.0\/ (“xmp”)
\nXMP Media Management: http:\/\/ns.adobe.com\/xap\/1.0\/mm\/ (“xmpMM”)
\nXMP Rights Management: http:\/\/ns.adobe.com\/xap\/1.0\/rights\/ (“xmpRights”)
\nXMP Basic Job Ticket: http:\/\/ns.adobe.com\/xap\/1.0\/bj\/ (“xmpBJ”)
\nXMP Paged-Text: http:\/\/ns.adobe.com\/xap\/1.0\/t\/pg\/ (“xmpTPg”)
\nPhotoshop: http:\/\/ns.adobe.com\/photoshop\/1.0\/ (“photoshop”)
\nStock Photo: http:\/\/ns.adobe.com\/StockPhoto\/1.0\/ (“bmsp”)
\nAdobe PDF: http:\/\/ns.adobe.com\/pdf\/1.3\/ (“pdf”)
\nCamera Raw Settings: http:\/\/ns.adobe.com\/camera-raw-settings\/1.0\/ (“crs”)
\nPNG: http:\/\/ns.adobe.com\/png\/1.0\/ (“png” )<\/p>\n

AND VERY IMPORTANT: Reference list of properties for the above schemas<\/a><\/p>\n

#target bridge<\/pre>\n
if (BridgeTalk.appName == “bridge” ) {
\nvar menu = MenuElement.create( “command”, “Export CSV File”, “at the end of Tools”);
\nmenu.onSelect = function(m) {
\ntry {
\nvar tDate = new Date();
\nvar tDay = parseInt(tDate.getMonth()+1)+’\/’+tDate.getDate()+’\/’+tDate.getFullYear();
\nvar f = File.saveDialog(“Export file list to:”, “Comma delimited file:*.CSV”);
\nif ( !f ) { return; }
\nf.open(“w”);
\nf.writeln(“DateProcessed,FileName,DateCreated,ImageWidth,ImageHeight,Latitude,Latitude2,Longitude,Longitude2,Altitude,ImageDirection”);
\nvar items = app.document.visibleThumbnails;
\nfor (var i = 0; i < items.length; ++i) {
\nvar item = items[i];
\nf.writeln(tDay,’,’,item.name,’,’,ListMetadata(item) );
\n};
\nf.close();
\n} catch(e) {}
\n};
\n};<\/p>\n
function ListMetadata(tn) {
\nmd = tn.metadata;
\nmd.namespace = “http:\/\/ns.adobe.com\/xap\/1.0\/”;
\nvar res = md.CreateDate;
\nmd.namespace = “http:\/\/ns.adobe.com\/tiff\/1.0\/”;
\nres = res + ‘,’ + md.ImageWidth + ‘,’ + md.ImageLength;
\nmd.namespace = “http:\/\/ns.adobe.com\/exif\/1.0\/”;
\nres = res + ‘,’ + md.GPSLatitude + ‘,’ + md.GPSLongitude + ‘,’ + md.GPSAltitude + ‘,’ + md.GPSImgDirection ;
\nreturn res;
\n}<\/p>\n
\"Screen Data now in Excel<\/center>NEXT POST: EXCEL TO TILEMILL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This is a documentation post for my own record on how I will produce a map of 180 date points that I have collected so far. To be honest I’m not a real programmer or anything like that, so the methods used in this post might be desultory or silly. I’m helplessly flapping about here. […]<\/p>\n","protected":false},"author":1,"featured_media":4464,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[785,783,775,771,777,780,779,770,781,782,778,773,784,776,586,769,774,544,587,772],"jetpack_featured_media_url":"https:\/\/dbbd.sg\/blog\/wp-content\/uploads\/2022\/03\/8166021546_03c481c032_o.png","_links":{"self":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts\/320"}],"collection":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/comments?post=320"}],"version-history":[{"count":1,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts\/320\/revisions"}],"predecessor-version":[{"id":4476,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/posts\/320\/revisions\/4476"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/media\/4464"}],"wp:attachment":[{"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/media?parent=320"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/categories?post=320"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbbd.sg\/blog\/wp-json\/wp\/v2\/tags?post=320"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}