{"id":1387,"date":"2010-02-07T18:23:54","date_gmt":"2010-02-08T01:23:54","guid":{"rendered":"http:\/\/journal2.alanv.org\/?p=1387"},"modified":"2012-10-09T21:16:39","modified_gmt":"2012-10-10T01:16:39","slug":"photo-dump","status":"publish","type":"post","link":"https:\/\/journal2.alanv.org\/?p=1387","title":{"rendered":"Photo Dump"},"content":{"rendered":"<p>I spent most of the morning tagging photos, managing to finish up September 2003. I&#8217;ll probably go to May 2004 next and tag backwards so I can start working backward on life.alanv.org as well.<\/p>\n<p>I also did some digging around and discovered that Adobe Photoshop Album (which I use) stores its tags in an Access database. This is actually kind of awesome, because it means I can export the information from the program into an XML file (or other format). Looking at a preliminary dump, it appears that there are two relevant tables: one for tags, which contains a row for each tag that basically gives the tag an ID (and stores information like parent tags and tag ordering), and one for photos, which contains a row for each photo that gives information like filename and path to the image. The photo table also contains a column that appears to be a base64-encoded bit vector. My assumption is that this bit vector is how the tags on each image are stored (based on the tag ID in the tag table). I&#8217;ll probably try writing a script to parse this stuff so I can generate dumps of tags by photo or similar. Still, it&#8217;s nice to know that I&#8217;m not locked in to using PSA forever, and can export my tags to some other program by some means.<\/p>\n<p>So yeah, without further ado, photodump from the past few weeks:<br \/>\n<img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710lunch.jpg\" \/><br \/>\nBrian and Danny at lunch after the volunteer event at Glide.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710simon.jpg\" \/><br \/>\nSimon at lunch after the volunteer event at Glide.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710cupcakes.jpg\" \/><br \/>\nAwesome cupcake boxes from the KaraVan.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710baybridge.jpg\" \/><br \/>\nThe Bay Bridge as seen from Colt Tower. Also a bit of downtown.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710kubb.jpg\" \/><br \/>\nA game of Kubb at work in the Spear 7 courtyard area.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710food.jpg\" \/><br \/>\nRelease food&#8230; Buca di Beppo this time.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710prettymatt.jpg\" \/><br \/>\nHe&#8217;s so pretty! :O<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710ally.jpg\" \/><br \/>\nAlly in her new apartment.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710hangers.jpg\" \/><br \/>\nThe Container Store&#8217;s awesome rainbow-colored selection of hangers. I was amused.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710matt.jpg\" \/><br \/>\nMatt hugging the roll of bubble wrap at the Container Store.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710fuzzylime.jpg\" \/><br \/>\nAlly contemplating the fuzzy lime at dinner at 21st Amendment.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710matt2.jpg\" \/><br \/>\nMatt in Shawn and Daniel&#8217;s awesome living room.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710shawn.jpg\" \/><br \/>\nShawn in his living room.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/journal2.alanv.org\/images\/20710shawnally.jpg\" \/><br \/>\nShawn and Ally attempting to restrain each other.<\/p>\n<p>Also, the <a href=\"http:\/\/life.alanv.org\/daily\">Daily Photo Project<\/a> seems to be good for me. It gets me out of the house at least once per day, and it&#8217;s making me notice things I never have before. I&#8217;ve been doing it every day, but uploads will be done in batches because it&#8217;s a pain to move files from one computer to the other.<\/p>\n<p>I am really missing my DSLR though, especially now that I&#8217;m forcing myself to take more different photos. I might have to get the D90 this month.<\/p>\n<p>Tonight is all-you-can-eat pizza at <a href=\"http:\/\/www.sf-local.com\/\">Local<\/a>. Om nom nom nom.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I spent most of the morning tagging photos, managing to finish up September 2003. I&#8217;ll probably go to May 2004 next and tag backwards so I can start working backward on life.alanv.org as well. I also did some digging around &hellip; <a href=\"https:\/\/journal2.alanv.org\/?p=1387\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,14],"tags":[],"class_list":["post-1387","post","type-post","status-publish","format-standard","hentry","category-code","category-photography"],"_links":{"self":[{"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=\/wp\/v2\/posts\/1387","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1387"}],"version-history":[{"count":0,"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=\/wp\/v2\/posts\/1387\/revisions"}],"wp:attachment":[{"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1387"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1387"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/journal2.alanv.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1387"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}