Monday, 17 September 2012

Importing Air Photos into Leapfrog


Some time back I received some air photos of the region I am currently working in from one of my colleagues. Last week I discovered that it is possible to easily import those photos into the program Leapfrog and thus see the lay of the land with respect to the locations of the various drill cores. However, he gave me six different photos but I only received corresponding “.tab” files for three of them. It is the data in the .tab files that tells the program how to import the photos—where are they located.  Therefore I set myself a quest: work out how to create .tab files for the other photos.  Having learned a number of things in the process, I thought I would share them here.

Step One in the process is deciding what points you want to use as markers.  Choose a place on the photo that is easily recognizable (like a cross-road intersection).  Then open GoogleEarth in one window and the air photo in another (using two monitors at once really helps!).  Zoom in to the selected location in google earth, and click on the thumb-tack shaped icon to get a marker. Drag that marker to where you want it, and give the marker a name (such as “T-intersection, upper left corner of Airphoto_a.jpg”), and save the location.  You can now look up the latitude and longitude of this point by clicking on it and selecting “properties”.

Step Two is to use an on-line form such as this one  (option: “Transverse Mercator Calculator”) to convert the latitude and longitude into the Swedish national grid known as RT-90 (that is the format of the drill hole locations with which I am working—if you are working in a different area you will need to instead convert to the appropriate coordinates for your area).

Step Three is to determine the X-Y coordinates on the photo itself of the selected location.  First look up the size of the photo by importing of it into Leapfrog without worrying about the fact that there is not yet a .tab file for it.  Then right-click on it to open the properties dialogue box and make note of the photo size (mine happened to be 1404 wide and 940 tall). (It is a good idea to now delete the photo from Leapfrog, since it is not, yet, in the correct spot). Now that you know the photo size that Leapfrog will be using, import the photo in CorelDraw, and change the size of the photo to those values.

Now you are ready to for Step Three itself: Use the “guidelines setup” dialogue box of CorelDraw to create two guidelines, one horizontal, one vertical, both located at zero. Then turn on the “snap to guidelines” feature and set the photo so that the upper left corner of the photo is located at the newly created 0,0 intersection.  At this point it is a good idea to “lock” the layer the photo is on so that you do not accidently move it during subsequent measurements.

Now that the photo is properly positioned drag new guidelines onto the photo such that they intersect at the spot you selected in Step One. Re-open the “guidelines setup” dialogue box and edit the position of those lines to the nearest whole number (e.g. 57.3456 becomes “57”) and look at the revised position to be certain you are happy with the location of the intersection of the guidelines.

Step Four: edit a .tab file with the numbers determined in Steps Two and Three.

The files he gave me have this format:

****************************
!table
!version 300
!charset WindowsLatin1

Definition Table
  File "airphoto_kriberg_a.jpg"
  Type "RASTER"
  (X,Y) (A,B) Label "Pt 1",
  (X,Y) (A,B) Label "Pt 2",
  (X,Y) (A,B) Label "Pt 3"
  CoordSys Earth Projection 8, 112, "m", 15.8082777778, 0, 1, 1500000, 0
  Units "m"
 ****************************

Where X and Y are the east and north coordinates of each spot in the RT90 format (Step Two) and A and B are the positions on the photo itself (Step Three).  Edit this to have the numbers you determined above, and repeat for two more spots on the photo.  Save as a .tab file in the same folder as the photo itself.

Step Five: import into Leapfrog.  If you edited the .tab file correctly choosing the “import image” option will open up a dialogue box that shows a circle, a square, and a triangle each superimposed over the photo on one of the three points of interest you selected. If they are in the correct spot click “ok” and your photo is imported.  If you don’t get a dialogue box but only an error message one possibility is that you could have introduced a blank space after the coma and before the next number. This is easily solved by deleting that space.

There may well be a simpler way (more automated) way to create .tab files for importing air photos into Leapfrog. If anyone knows of one do please share in a comment.  In the meantime writing down what I did will help me remember next time I need to do this.