listing of images in the Interstate 91 database that are marked as Thetford, but that are actually in Fairlee.

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…

This one has been lingering for a while.

Turns out from Interstate project we have a couple hundred images in the wrong town…list below.

I could of course fix these one by one but I am betting/hoping you know a better way.  If it helped, I could easily make them into a list by LS# in excel.

Ideas?

 

I WAS GIVEN SOMETHING WHICH LOOKED LIKE THIS

 

160 McCarty House, Second-Floor Hallway 1969 Thetford Orange Vermont State Archives and Records Administration LS49489_000
161 McCarty House, Second-Floor Room 1969 Thetford Orange Vermont State Archives and Records Administration LS49490_000

162 McCarty House, Living Room 1969 Thetford Orange Vermont State Archives and Records Administration LS49491_000
163 McCarty House, Kitchen 1969 Thetford Orange Vermont State Archives and Records Administration LS49492_000

164 McCarty House, Bathroom 1969 Thetford Orange Vermont State Archives and Records Administration LS49493_000
165 McCarty House, Boiler Room 1969 Thetford Orange Vermont State Archives and Records Administration LS49494_000

166 McCarty House, First-Floor Room 1969 Thetford Orange Vermont State Archives and Records Administration LS49495_000
167 McCarty House, Cellar 1969 Thetford Orange Vermont State Archives and Records Administration LS49496_000

 

I converted it to this:

update  images 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”)

 

To which Paul remarked, “You are AWESOME!”

About Wesley Wright

Born on a mountain top near New York City, Craziest state in the land of the pretty. Raised in the woods so's he knew every tree, Killed him a bear when he was only three.
This entry was posted in Wes and tagged , , . Bookmark the permalink.