Once agin I climb the electron mountain... I have a set of digital photos and GPS coordinates of the thalwag of a creek. My desire is to link the two in some way as to enable what AV cals hot-linking i.e. when one hovers or clicks on a point in the browser, the image will "popup" on the screen if the hotlinking ability is turned on.
My problem is that I hate to rename the photos and lose their original identity, but I have to as the camera only names the photos by date and sequential number ....p8010001.jpg etc. Thus I have five dates with similar photo sequential numbers.....p8010001.jpg, p807001.jpg, etc. I have and Excel table which has one column for the photo id and other columns for gps coord and attributes. My initial though was to just add another column with Unique_ID numbered as 1,2,3,....n to the sorted list. Here is an example of the current spreadsheet format: Unique_IDDatePhotoGPSPhotoIDLongLatINFLOWCROSSINGOTHER A13480102b033p8010033-123.34528844.925778riprap A13580102b034p8010034-123.34528544.925785 A13680102b035p8010035-123.34472444.925668 A13780102b036p8010036-123.3442744.925426 A13880102b037p8010037-123.3439544.925242Culvert A13980102b038p8010038-123.34378344.925198 A14080102b039p8010039-123.34373844.925178Tributary The first letter is just a means I used to sort the photo files linearly to match the upstream to downstream configuration. I just thought I might ask the list if this was the best way to handle it or if there was a more elegant solution?? Thanks in advance...tom ==================================================== Tom Thomson Northwest Agricultural Consulting 1275 Oak Villa Road [EMAIL PROTECTED] Dallas, Oregon 97338 Phone/FAX 503-623-0468 "The only difference between a problem and a solution is that everyone understands the solution." Charles Kettering ====================================================
