{"id":959,"date":"2014-12-03T16:36:39","date_gmt":"2014-12-03T20:36:39","guid":{"rendered":"http:\/\/blog.uvm.edu\/ctl-projects\/?p=959"},"modified":"2014-12-03T16:36:39","modified_gmt":"2014-12-03T20:36:39","slug":"listing-of-images-in-the-interstate-91-database-that-are-marked-as-thetford-but-that-are-actually-in-fairlee","status":"publish","type":"post","link":"https:\/\/blog.uvm.edu\/waw\/2014\/12\/03\/listing-of-images-in-the-interstate-91-database-that-are-marked-as-thetford-but-that-are-actually-in-fairlee\/","title":{"rendered":"listing of images in the Interstate 91 database that are marked as Thetford, but that are actually in Fairlee."},"content":{"rendered":"

On Nov 21, 2014, at 3:41 PM, Paul Bierman <paul.bierman@uvm.edu<\/a>> wrote:<\/p>\n

Hi Wes,<\/em><\/p>\n

Trying to clean up lots of things now the semester is winding down\u2026<\/em><\/p>\n

This one has been lingering for a while.<\/em><\/p>\n

Turns out from Interstate project we have a couple hundred images in the wrong town\u2026list below.<\/em><\/p>\n

I could of course fix these one by one but I am betting\/hoping you know a better way. \u00a0If it helped, I could easily make them into a list by LS# in excel.<\/em><\/p>\n

Ideas?<\/em><\/p>\n

 <\/p><\/blockquote>\n

I WAS GIVEN SOMETHING WHICH LOOKED LIKE THIS<\/p>\n

 <\/p>\n

\n
\n
\n

160 McCarty House, Second-Floor Hallway <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49489_000
\n161 McCarty House, Second-Floor Room <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49490_000<\/p>\n

162 McCarty House, Living Room <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49491_000
\n163 McCarty House, Kitchen <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49492_000<\/p>\n

164 McCarty House, Bathroom <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49493_000
\n165 McCarty House, Boiler Room <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49494_000<\/p>\n

166 McCarty House, First-Floor Room <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49495_000
\n167 McCarty House, Cellar <\/span>1969 Thetford Orange Vermont State Archives and Records Administration LS49496_000<\/p>\n

 <\/p>\n

I converted it to this:<\/p>\n

update \u00a0images set TOWN=’Fairlee’ where ls in (“49489″,”49490″,”49491″,”49492″,”49493″,”49494″,”49495″,”49496″,”49497″,”49498″,”49499″,”49500″,”49501″,”49502″,”49503″,”49504″,”49505″,”49506″,”49507″,”49508″,”49509″,”49510″,”49511″,”49512″,”49513″,”49514″,”49521″,”49522″,”49523″,”49524″,”49525″,”49526″,”49527″,”49528″,”49529″,”49530″,”49531″,”49532″,”49533″,”49534″,”49535″,”49536″,”49537″,”49538″,”49539″,”49540″,”49558″,”49559″,”49560″,”49561″,”49562″,”49563″,”49564″,”49565″,”49566″,”49567″,”49568″,”49569″,”49570″,”49571″,”49572″,”49573″,”49574″,”49575″,”49576″,”49577″,”49578″,”49579″,”49580″,”49581″,”49582″,”49583″,”49584″,”49585″,”49586″,”49587″,”49588″,”49589″,”49590″,”49591″,”49592″,”49593″,”49594″,”49595″,”49596″,”49597″,”49620″,”49621″,”49622″,”49623″,”49624″,”49625″,”49628″,”49629″,”49630″,”49631″,”49632″,”49633″,”49634″,”49635″,”49636″,”49637″,”49638″,”49639″,”49640″,”49641″,”49642″,”49643″,”49644″,”49645″,”49646″,”49647″,”50296″,”50297″,”50298″,”50299″,”50300″,”50301″,”50302″,”50303″,”50304″,”50305″,”50306″,”50307″,”50308″,”50309″,”50310″,”50311″,”50318″,”50319″,”50320″,”50321″,”50322″,”50323″,”50324″,”50325″,”50326″,”50327″,”50328″,”50329″,”50330″,”50331″,”50332″,”50333″,”50334″,”50335″,”50336″,”50337″,”50338″,”50339″,”50340″,”50341″,”50342″,”50343″,”50344″,”50345″,”50346″,”50347″,”50348″,”50349″,”50350″,”50351″,”50352″,”50353″,”50354″,”51183″,”51184″,”51185″,”51186″,”51187”,”51189\u201d)<\/span><\/p>\n

 <\/p>\n

To which Paul remarked, “You are AWESOME!”<\/span><\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

On Nov 21, 2014, at 3:41 PM, Paul Bierman <paul.bierman@uvm.edu> wrote: Hi Wes, Trying to clean up lots of things now the semester is winding down\u2026 This one has been lingering for a while. Turns out from Interstate project we … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41826],"tags":[42758,12386,45193],"class_list":["post-959","post","type-post","status-publish","format-standard","hentry","category-wes","tag-boffins","tag-database","tag-geology-landscape-change"],"_links":{"self":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/959","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/comments?post=959"}],"version-history":[{"count":0,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/posts\/959\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/media?parent=959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/categories?post=959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.uvm.edu\/waw\/wp-json\/wp\/v2\/tags?post=959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}