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_ID Date PhotoGPS PhotoID
Long Lat INFLOW CROSSING OTHER
A 134 80102b033 p8010033 -123.345288 44.925778
riprap
A 135 80102b034 p8010034 -123.345285 44.925785
A 136 80102b035 p8010035 -123.344724 44.925668
A 137 80102b036 p8010036 -123.34427 44.925426
A 138 80102b037 p8010037 -123.34395 44.925242
Culvert
A 139 80102b038 p8010038 -123.343783 44.925198
A 140 80102b039 p8010039 -123.343738 44.925178
Tributary
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
====================================================
